How to get records randomly from the oracle database? January 13, 2023 by Tarik SELECT * FROM ( SELECT * FROM table ORDER BY DBMS_RANDOM.RANDOM) WHERE rownum < 21;