While working on sample quiz application on ADF i got requirement to return the random questions from the table for every quiz user. For this I used DBMS_RANDOM package
I feel it would be cool to share it.
Example: Return Random 30 rows from the table
select mycolumn from ( SELECT mycolumn FROM MyTable ORDER BY dbms_random.value ) where rownum <= 30;