Re: dbms_random package; etc

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 18 Oct 2001 21:37:33 GMT
Message-ID: <3bcf4b3d.626498296@news.alt.net>

On Thu, 18 Oct 2001 20:15:59 GMT, "Cosmin Ioan" <cosmini_at_mediaone.net> wrote:

>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.

What is the exact statement you are using?

>
>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?

That would probably depend on how you arfe sampling. Have you looked at the SAMPLE clause?

Brian Received on Thu Oct 18 2001 - 16:37:33 CDT