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 have
> implemented from textbooks (pseudo-random number generation) go into
> repeating
> loops 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_at_hpd.abbott.com
--
A good workaround is the GET_TIME feature from DBMS_UTILITY. Extract the
100ths of seconds and you have 100 random numbers each second.
Received on Wed Apr 02 1997 - 00:00:00 CST
