Dev Corner

Software Developer’s Notepad

Select Random Record from Oracle Database

baobab under Oracle Tips

There are lots of ways to select a random record or row from Oracle database table. Here is an example SQL statement.

To select a random record with Oracle:

   SELECT first_name, last_name
     FROM customer
    ORDER BY dbms_random.value;

To select only one random record from Oracle database table:

   SELECT first_name, last_name
     FROM (SELECT first_name, last_name
             FROM customer
            ORDER BY dbms_random.value)
    WHERE ROWNUM = 1;

To limit the number of random records returned by SELECT statement in Oracle to 10:

   SELECT first_name, last_name
     FROM (SELECT first_name, last_name
             FROM customer
            ORDER BY dbms_random.value)
    WHERE ROWNUM < 10;
« How to find current post tags in WordPress
Select Random Record in PostgreSQL »

Add A Comment

You must be logged in to post a comment.

Subscribe to Dev Corner