Intermediate results with aliases - when does it work?

From: vezerid <vezerid_at_act.edu>
Date: Thu, 29 Nov 2007 06:53:16 -0800 (PST)
Message-ID: <56e7e77e-0883-4df7-a9a9-973cc2ded6c4@w28g2000hsf.googlegroups.com>

Hello all,

please consider the following query:

select 12*sal yearly, yearly+comm
from emp;

I would expect that the alias can be used in the next output field of SELECT. Oracle complains:

select 12*sal yearly, yearly+comm

                      *

ERROR at line 1:
ORA-00904: invalid column name

However, I am sure I have seen such alias use for intermediate results in the past. When can this feature be used?

Kostis Vezerides Received on Thu Nov 29 2007 - 08:53:16 CST