Use this query to select a random record from Oracle table. This works from TOAD as well as sqlplus: SELECT col_name FROM (SELECT col_name FROM table_name ORDER BY dbms_random.value) WHERE rownum = 1;
© 2005 tiplib.com