Re: Selecting a random sample of data using PL/SQL

John L Dunn wrote:
>
> Anybody written PL/SQL code to select records from a table randomly? For
> instance, I've got a 2,000,000 row table and I want a random sample of
> 10,000; how do I do it using PL/SQL? Or is it better to punt and use a
> 3GL/4GL for this purpose?
>
> Any help appreciated! TIA,
>
> John Dunn
> The University Physicians

With Form 3.0, ORACLE did not had random function. I had to use Pro*C to do this. I guess they don't have this function even with forms 4.5.

-- 

Muhammad A. Malik
mamalik_at_cs.wmich.edu
+1 (616) 342-4569