From: Eduardo Rene Rodriguez Avila Subject: Re: Random Number Generation in PL/SQL Date: 1997/04/04 Message-ID: <334532E6.7674@geocities.com>#1/1 References: <5hp3kd$ler3@fizban.pprd.abbott.com> To: "Jeffrey P. Rudnick" Organization: UPIICSA Reply-To: e.r.rodriguez@ieee.org Newsgroups: comp.databases.oracle.misc Jeffrey P. Rudnick wrote: > > Has anyone come across a random number generation function written in > PL/SQL? We are in need of random number generation over a variable > domain of numbers. For example: we may need 20 random numbers between 1 > and 75, and later 30 random numbers between 1 and 2,000. > > Some of the algorithms we tried to implement from textbooks > (pseudo-random number generation) go into loops which repeat the > same number sequence after a short period of time. > > If anyone has a PL/SQL random number algorithm they can share, we would > greatly appreciate it. > > Regards, > > rudnijp@hpd.abbott.com Well, some time ago a write this for an simple application: . . . IF seed=0 THEN seed := EXP(TO_NUMBER(TO_CHAR(SYSDATE,'SS'))/59); END IF; seed := 1/(seed - TRUNC(seed)); seed := seed - TRUNC(seed); . . . I hope be useful... -- Saludos desde México... Greetings from Mexico... _/ _/ M. en C. Eduardo Rene Rodriguez Avila _/ _/ _____/ Database and UNIX Systems Administrator, Technical Support, MIS, E-Mail: e.r.rodriguez@ieee.org Cablevision, S.A. de C.V. eravila@spin.com.mx D.F., Mexico. WWW : http://spin.com.mx/~eravila =============================================================================================== __ __