Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Random Numbers in PL/SQL
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
![]() |
![]() |