Re: Randomizing ...

In article <8urshh$a45$1_at_nnrp1.deja.com>,   sergey_s_at_my-deja.com wrote:
> How can I select a number of random rows from a table? Say I wanted to
> select 500 random IDs from a table, how would I do that? I was trying
> to find a random number generator function in SQL or PL/SQL, but
 didn't
> see one so far. I guess I could use mod. Are there any other ways?
>
> Oracle 8.0.5
>
> Thank you!
> Sergey
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

There is a random generator in pl/sql in Oracle 8.0 and beyond. It is called -guess what- dbms_random.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.