Default sorting order used by oracle
710767Jul 8 2009 — edited Jul 8 2009Can anyone please let me know whether oracle uses any default sort order or not when executing an sql which does not have any sort order/ order by clause?
I have a sql query where no sort order is specified.
Now if I add some more columns in the select clause and execute the same query, the number of records returned are same and also the records are same.
But the order in which they are displayed is different from the previous query.
Could anyone please let me know whether oracle uses any default sort order or not when executing an sql which does not have any sort order/ order by clause
or does it depend on the columns of the table?
Thanks in advance.