Order of execution of Select clauses

Hi All,

Please correct me if i am wrong.

Internally, the order of execution for a SELECT statement is as follows:
FROM clause
WHERE clause
SELECT clause
ORDER BY clause
and Oracle allows Order by the table columns that are not included in the SELECT clause.

If Order By clause is executed after select clause in select statement, then how does Oracle Order by columns that are not included in the SELECT clause internally.

Thanks in Advance
Pria Received on Fri Feb 10 2006 - 15:30:03 CST