Selecting random rows from an oracle table

Friday, 8 June 2007, 1:20 | Category : Database, Technology
Tags :

SELECT * FROM (SELECT * FROM TEST_TABLE ORDER BY dbms_random.value) WHERE rownum <= 5;
This will give 5 random rows from table.