Re: Selecting a random row from a table

Well since no one has replied here's my suggestion - which I find rather messy:

Use a cursor to select the data into a vararray

Get a random number between 1 and count(*) - using the rand_int function from technet.

Get the value of the vararray with an index equal to that of the random number

Anyone got any better suggestions??

Paul Davies wrote in message <375939d2_at_newsread3.dircon.co.uk>...
>I'm wish a select a single row randomly from a table.
>
>Can someone tell me how to do this using PL/SQL?
>
>Thanks
>
>Paul
>
>
Received on Mon Jun 07 1999 - 10:58:24 CDT