Select Random Rows from Table in Oracle

To select 10 random records from a table in Oracle

SELECT * FROM
( SELECT * FROM TABLE_NAME
ORDER BY dbms_random.value )
WHERE rownum <= 10 ;

Leave a Reply