http://www.trutek.com/serendipity/index.php?/archives/51-PLSQL-Tips-by-Dan-Stober.html
Friday, May 27, 2011
Cources
Advanced Database Programming
http://ist.marshall.edu/ist480adbp/dbms_random
http://www.adp-gmbh.ch/ora/plsql/dbms_random.html
Select a random record with Oracle:
SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1Thanks Mark Murphy
Subscribe to:
Posts (Atom)