Re: random numbers

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1999/11/10
Message-ID: <+nwpOIjfpQPy7OBXmsVte4ZRKE=q@4ax.com>#1/1

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

Received on Wed Nov 10 1999 - 00:00:00 CST