Randomizing Functionality?

From: Frank Siegel <NorthernSnow_at_worldnet.att.net>
Date: 26 Jan 1999 01:48:32 GMT
Message-ID: <78j6tg$kdd@bgtnsc02.worldnet.att.net>

I have a table with 300K rows with each row numbered 1 to 300,000 (not an Oracle sequence object). Let's call this column PAT_NUM. It is my understanding that Oracle does not have a RANDOM function.

Do you know of a random algorithm I can use to select random rows based on the the coulmn PAT_NUM?

I have the user of a cursor within a stored procedure if it would help. Or I can use PL/SQL programming constructs within a stored procedure is that helps.

Please shed some light! Thanks!
Frank S., New Hampshire Received on Mon Jan 25 1999 - 19:48:32 CST