Select Random Rows from Table in Oracle By Shadab Mohammad • Dec 12, 2012 • No comments To select 10 random records from a table in Oracle SELECT * FROM ( SELECT * FROM TABLE_NAME ORDER BY dbms_random.value ) WHERE rownum <= 10 ; Share this: Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on WhatsApp (Opens in new window) WhatsApp Category: Database • SQL Tags: dbms_random.value • Random • Select • SQL • Values