Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: random in PL/SQL
The easiest ways to get pseudo-random numbers is to (1) use dbms_random (as
others have mentioned) or (2) use an external procedure to call the random
number generator on the operating system.
However, if you want a set of true random numbers, look at http://www.random.org
You can store these numbers and then use them as desired.
Frank Hubeny
Jan Eliasen wrote:
> Hi there.
>
> I can't find a random function in PL/SQL - can that be true? I've searched
> through all the documentation I could find.
>
> So what do I do if I want a random number between 18 and 100?
>
> --
> Eliasen Jr.
Received on Sun Dec 16 2001 - 21:13:45 CST