Random Number Generation in PL/SQL

From: Jeffrey P. Rudnick <rudnijp_at_hpd.abbott.com>
Date: 1997/03/31
Message-ID: <5hp38s$ler2@fizban.pprd.abbott.com>#1/1

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 Received on Mon Mar 31 1997 - 00:00:00 CST