re: dbms_random package; etc

From: Cosmin Ioan <cosmini_at_mediaone.net>
Date: Thu, 18 Oct 2001 20:15:59 GMT
Message-ID: <3MGz7.5182$1R5.672550@typhoon.jacksonville.mediaone.net>

hi all, I have a two-fold problem:

a). I am trying to use the dbms_random package to get a random number and for some weird reason, even though initialize to a value X the Random function always returns a number larger then X.

b). Related to the above, I am trying to obtain a sample of records from let's say a 20 mill. recordset. Would using rownum with the above package be my fastest solution?

thx much,

Cosmin

P.S. Unfortunately, I am constrained to whatever packages are in Oracle 8.1.6.2, ie, I cannot bring in outside packages. Received on Thu Oct 18 2001 - 15:15:59 CDT