Re: random numbers

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 10 Nov 1999 19:08:03 +0800
Message-ID: <38295213.7996@yahoo.com>

Thomas Kyte wrote:
>
> A copy of this was sent to marcus_chan_at_my-deja.com
> (if that email address didn't require changing)
> On Wed, 10 Nov 1999 10:01:22 GMT, you wrote:
>
> >Hello,
> >
> >Does Oracle provides function "random generation of unique numbers"?
> >thanks
> >
>
> no.
>
> there is a random number generator (dbms_random) but it will generate the same
> number.
>
> there are sequences which generate unique (but predictable) numbers.
>
> what are you trying to do? maybe we can suggest a way to do that.
>
> >marcus
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation

You can set up the linear congruential generator to give a non-repeating set of "random" numbers.

www.nr.com has some algorithms to do so, although I'd be curious in knowing what the original poster had in mind...

Cheers
Connor
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 10 1999 - 05:08:03 CST