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