Our DBAs are in need of a UNIX "random number generator", as requested
below. We would appreciate some input.
Thanks!
---------------------------------------------------------------
"We would be creating a file of n lines and want to randomly select 20 lines
from the original file into another file. The original information comes
from a database, but we don't know of a database solution. Therefore, the
idea is to write the information to a Unix file, then try to find a Unix
solution to the problem. "
"Use a Unix random number generator to generate 20 random numbers
Select from table where row_number in (ran1, ran2,... ran20)
I assume Unix has a random number function?"
Received on Wed Aug 02 2000 - 23:34:11 NZST