Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Randomize data from SQL statement
Hi,
I want to generate a 30% random sample output data from my Order_number field of my Order_item table. Is there any technique or function that I could use?. I would like it to be done in SQL Statement not in PL/SQL.
Thanks
Tricia Kha
tkha_at_accesscom.com
Received on Mon Sep 21 1998 - 00:00:00 CDT