default order by

[amits]

If a order by clause is not there in a query ,so it will sort randomly or based on some index.

[Raminder]

Oracle or any relational database does not guarantee output in any order since table is basically an unordered set of rows. You can expect output in random order.

[julian]

Originally posted by Raminder
Oracle or any relational database ...[/B]

Let's say almost relational database :-)