How to select random rows from result set in oracle

Question

I tried both these queries but none of them seem to work: I wish to fetch random rows from result set in oracle

select * from TABLE_NAME t where t.ent_application_id = 13101192 order by Dbms_Random.Random

select * from TABLE_NAME t where t.ent_application_id = 13101192 order by Dbms_Random.Value

score 1 · Answer 1 · answered Mar 13 '14 at 09:55

1

Try

SELECT T.COLUMN1, T.COLUMN2, DBMS_RANDOM.VALUE
FROM TABLE_NAME T 
WHERE T.ENT_APPLICATION_ID = 13101192 
ORDER BY 3

answered Mar 13 '14 at 09:55

DNac

2,343
7
26
52

This did not work either :( – fiddle Mar 13 '14 at 10:58
How come? Do you have more records in the T table that have this application ID? – DNac Mar 13 '14 at 12:24
No there is just one. – fiddle May 05 '14 at 05:38

How to select random rows from result set in oracle

1 Answers1