Re: Random Number Generator SEED

In article <41vnr4$koi_at_darwin.nbnet.nb.ca>, godbouts_at_gov.nb.ca (Stephane C. Godbout) writes:
> Good Day !!
>
> After having determined that Oracle does not have a random number generator, I programed one.
> The generator (after being given a seed) will provide a number between 0 and 1.
>
> The seed has to be between 1 and 2,147,483,647. I was thinking of using the milliseconds stamp
> off of the computer however, It seems that Oracle doesn't have a function to do this.

Have a close look at the V$TIMER database object as I think it gives you the type of seed you want.

Bruce... pihlab_at_cbr.hhcs.gov.au

• Bruce Pihlamae -- Database Administration *
• Commonwealth Department of Human Services and Health *
• Canberra, ACT, Australia (W) 06-289-7056 * *=================================================================*
• These are my own thoughts and opinions, few that I have. *

  ---

"The more complex the argument gets, the easier it is to refute." "Killing is wrong!" -- Trent 'The Uncatchable' Castanaveras Received on Fri Sep 01 1995 - 00:00:00 CEST