A question about Randomness in Oracle?

Hi all,

I have been looking at

F:\oracle\ora92\rdbms\admin\dbmsrand.sql

It says

"This is a random number generator. Do not use for cryptography"

Do Oracle publish any details of the algorithm they use to generate these numbers?

Basically, what I have is a certain number of records, each with an integer (sequence), and I want to be able to do something like

SELECT * FROM My_Table (RANDOM x 1000) ORDER BY My_Sequence

or whatever the syntax is in Oracle. I want 1000 RANDOM records - i.e. if I do this tomorrow or the next day, I will get a completely different set of records. Is there an easy way to do this in Oracle?

Paul...

-- 
plinehan  y_a_h_o_o  and d_o_t  com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.



"XML avoids the fundamental question of what we should do, 

by focusing entirely on how we should do it." 

quote from http://www.metatorial.com