Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Random Numbers in PL/SQL

Re: Random Numbers in PL/SQL

From: Andrew Babb <andrewb_at_mail.com>
Date: Tue, 27 Apr 1999 21:42:29 +0800
Message-ID: <3725BEC4.6AE42FC8@mail.com>


Hi,

If you have access to Oracle8i, you can use the SAMPLE key word on the select statement which I think will do what you are looking for. Sorry, I have not tried this out yet, but I have read about it.

Andrew

youngsod_at_my-dejanews.com wrote:

> Sorry if this has been asked before, but I need some help.
>
> I have a table with around 27000 records at present and growing.
>
> The primary key is a varchar2(7) ID 1234567 , not created sequentially.
>
> I need to be able to get a random sample of 100 records from the table.
>
> Any ideas ?
>
> Douglas
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 27 1999 - 08:42:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US