Wernfried Domscheit February 2016
Under some circumstances you don't need an
ORDER BY clause.
Let's say you have table
EMP with an index on column
Such query does not require an
ORDER BY clause the result will be ordered automatically by
WHERE EMP_ID > 10;
However, you should not rely on that. In some conditions Oracle may behave different.