Random Number Generation in PL/SQL
From: Jeffrey P. Rudnick <rudnijp_at_hpd.abbott.com>
Date: 1997/03/31
Message-ID: <5hp3m6$ler4_at_fizban.pprd.abbott.com>#1/1
Date: 1997/03/31
Message-ID: <5hp3m6$ler4_at_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 CEST