Category : Databases > Oracle

Select random row from Oracle table

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;

Details

Tip reference : #82 views : 3109

Added on : 02/16/06

Submited by : h8dk97