Re: random in PL/SQL

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Sun, 16 Dec 2001 19:13:45 -0800
Message-ID: <3C1D62E9.26DB3D15@ntsource.com>

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