Select Random Rows from Table in OracleBy Shadab Mohammad • Dec 12, 2012 • No commentsTo select 10 random records from a table in OracleSELECT * FROM ( SELECT * FROM TABLE_NAME ORDER BY dbms_random.value ) WHERE rownum <= 10 ; Share this:Click to share on Twitter (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on WhatsApp (Opens in new window)Category: Database • SQLTags: dbms_random.value • Random • Select • SQL • Values