How to get random multiple rows from any table in Oracle

Question

How to get random output of multiple rows from any table in Oracle? Also what is the meaning of (dbms_random.value)

select *
from (select *
      from emp
      order by dbms_random.value)
where rownum=1;

It gives only one random output. How do I get multiple?

Kshitij · Accepted Answer · 2012-05-29 08:49:19Z

2

try

select * from (select * from emp order by dbms_random.value) where rownum<10

10 can be replaced by any other count of your choice

answered May 29, 2012 at 8:49

Kshitij

8,6642 gold badges29 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

sir, what is the meaning of dbms_random.value

Its an inbuild random number generator for oracle.

I am glad i could help you. Will appreciate if you can accept the answer.