How to get records randomly from the oracle database?

by 
SELECT *
FROM   (
    SELECT *
    FROM   table
    ORDER BY DBMS_RANDOM.RANDOM)
WHERE  rownum < 21;

More Related Contents:

  1. How to use a table type in a SELECT FROM statement?
  2. Oracle date difference to get number of years
  3. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  4. List of foreign keys and the tables they reference in Oracle DB
  5. What is the dual table in Oracle?
  6. ORA-28040: No matching authentication protocol exception
  7. hibernate oracle sequence produces large gap
  8. How to handle Day Light Saving in Oracle database
  9. How to avoid variable substitution in Oracle SQL Developer
  10. How to choose a weighted random array element in Javascript?
  11. Recursion In Oracle
  12. How to kill a running SELECT statement
  13. creating parameterized views in oracle11g
  14. Oracle’s default date format is YYYY-MM-DD, WHY?
  15. PL/SQL print out ref cursor returned by a stored procedure
  16. quick selection of a random row from a large table in mysql
  17. Default Schema in Oracle Connection URL
  18. how to replace multiple strings together in Oracle
  19. Dynamically pivoting a table Oracle
  20. URL string format for connecting to Oracle database with JDBC
  21. Convert epoch to date in sqlplus / Oracle
  22. Why are Oracle table/column/index names limited to 30 characters?
  23. What is the difference between precision and scale?
  24. Get the number of days between two dates in Oracle, inclusive of the dates
  25. How to output result of SELECT statement which is executed using native dynamic SQL?
  26. Cursor For Loop with dynamic SQL-Statement
  27. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  28. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  29. How to test an Oracle Stored Procedure with RefCursor return type?
  30. Getting Error – ORA-01858: a non-numeric character was found where a numeric was expected

Leave a Comment