Re: Order of execution of Select clauses

"Pria" <Pria79_at_gmail.com> wrote:
> 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

Clauses are not executed at all, and therefore there is no order for them to be executed in.

> 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.

Accepting a false (or non-sensical) premise can lead to all kinds of bizarre conclusions.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB