Re: Pl/SQL: How do you Randomize?

From: James Petts <jpetts_at_celltech.co.uk>
Date: Wed, 24 Feb 1999 16:52:19 GMT
Message-ID: <36d42e17.193937827@firewall.celltech>

On 24 Feb 99 16:23:26 GMT, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:

> 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?
>

Take a look at:

http://www.revealnet.com/plsql-pipeline/archives.htm#code03

Written by Kevin Taufner.

BTW, hitting the return key after about 70 or so columns is A Good Thing.

James Received on Wed Feb 24 1999 - 10:52:19 CST