Re: Randomizing Functionality?

Hi, Frank:

Oracle does indeed have a random number function (in Oracle8 at least). Take a look at the DBMS_RANDOM package.

                          Rick

"Frank Siegel" <NorthernSnow_at_worldnet.att.net> writes:

> I have a table with 300K rows with each row numbered
> 1 to 300,000 (not an Oracle sequence object). Let's
> call this column PAT_NUM. It is my understanding
> that Oracle does not have a RANDOM function.
>
> Do you know of a random algorithm I can use to select
> random rows based on the the coulmn PAT_NUM?
>
> I have the user of a cursor within a stored procedure
> if it would help. Or I can use PL/SQL programming
> constructs within a stored procedure is that helps.
>
> Please shed some light! Thanks!
> Frank S., New Hampshire
>
>
>
>
>

-- Received on Tue Jan 26 1999 - 16:09:48 CST