Snippet Name: Selecting a Random Row Description: Sometimes all you need is a random row. This will do it for you. Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 24th, 2009
Description: Sometimes all you need is a random row. This will do it for you.
SELECT column FROM ( SELECT column FROM TABLE ORDER BY DBMS_RANDOM.VALUE ) WHERE ROWNUM = 1
