Random Number Generation in PL/SQL

From: Jeffrey P. Rudnick <rudnijp_at_hpd.abbott.com>
Date: 1997/03/31
Message-ID: <5hp3kd$ler3@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 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_at_hpd.abbott.com Received on Mon Mar 31 1997 - 00:00:00 CST