Default row ordering for select query in oracle

by

According to Tom Kyte: “Unless and until you add “order by” to a query, you cannot say ANYTHING about the order of the rows returned. Well, short of ‘you cannot rely on the order of the rows being returned’.”

See this question at asktom.com.

As for ROWNUM, it doesn’t physically exist, so it can’t be “freed”. ROWNUM is assigned after a record is retrieved from a table, which is why “WHERE ROWNUM = 5” will always fail to select any records.

@ammoQ: you might want to read this AskTom article on GROUP BY ordering. In short:

Does a Group By clause in an Query gaurantee that the output data will be
sorted on the Group By columns in
order, even if there is NO Order By
clause?

and we said…

ABSOLUTELY NOT,

It never has, it never did, it never
will.

More Related Contents:

  1. Maximum Number of times we can query an oracle database [closed]
  2. Place to store PL/SQL block [closed]
  3. How do I escape a reserved word in Oracle?
  4. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  5. Fetch Oracle table type from stored procedure using JDBC
  6. “Safe” TO_NUMBER()
  7. When or Why to use a “SET DEFINE OFF” in Oracle Database
  8. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  9. error: ORA-65096: invalid common user or role name in oracle
  10. Oracle insert if not exists statement
  11. Error : ORA-01704: string literal too long
  12. Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
  13. Oracle client ORA-12541: TNS:no listener [closed]
  14. Reason why oracle is case sensitive?
  15. Create an Excel Spreadsheet from a Oracle Database
  16. How do I turn off Oracle password expiration?
  17. ORACLE IIF Statement
  18. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  19. SQL Fiddle Output Error
  20. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  21. Oracle Age calculation from Date of birth and Today
  22. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  23. How to list active / open connections in Oracle?
  24. ORA-12705: Cannot access NLS data files or invalid environment
  25. jboss 7 oracle datasource configuration
  26. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment