Friday, May 27, 2011

Tips

http://www.trutek.com/serendipity/index.php?/archives/51-PLSQL-Tips-by-Dan-Stober.html

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 = 1
Thanks Mark Murphy