Re: Randomizing ...

From: justvrk <justvrk_at_hotmail.com>
Date: Wed, 15 Nov 2000 17:28:29 -0500
Message-ID: <8uv2mh$6rs$1@new-proxy.bscc.bls.com>

Hi,
check out http://govt.oracle.com/~tkyte/Misc/Random.html

HTH,
justvrk

sergey_s_at_my-deja.com wrote in message <8urshh$a45$1_at_nnrp1.deja.com>...
>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.
Received on Wed Nov 15 2000 - 16:28:29 CST