Pl/SQL: How do you Randomize?

        I am writiing a PL/SQL procedure and need to create an eight letter word that is just a random set of letters - i.e. creating a users "first" password for the system. I could do a for loop and use the CHR() function to turn it inot a letter and then concatenate the letters but a for loop provides no randomness - is there a Rnd function in PL/SQL? Or is there a better way to make an eight letter random word?

Thanks,
Sean Dolan
sean_at_3si.com Received on Wed Feb 24 1999 - 10:23:26 CST