Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: random numbers
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 10 1999 - 05:08:03 CST
![]() |
![]() |