[oracle] random order by SELECT * FROM table ORDER BY DBMS_RANDOM.VALUE Carpe Programming/oracle 2011.11.22