Re: generate random numbers

Vince <vincent@ wrote:

> hi there !
>
> I would like to use random numbers in my pl/sql code..
> do I really need to user dbms_random package or there is another to do
> so ?
> if so, how could I use dbms_random to generate positive random
> numbers??
>
> thanks a lot..
> Vince

Depends on the version of Oracle.

DBMS_RANDOM isn't really. Which is why, with 10g, true random number generation was built into the DBMS_CRYPTO package.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)