artmt_at_hotmail.com wrote:
> DA Morgan wrote:
>> Martin T. wrote:
>>> Hello all.
>>> (assuming Oracle 9.2)
>>>
>>> First of all, does anyone know why the Oracle SQL Parser will not allow
>>> us to use the <name>-part of "table.column AS <name>" in where or
>>> group-by clauses?? Is this just being lazy on their part, or is there
>>> an actual reason behind this?
>> Just read the above paragraph a second time. I have no idea what you
>> are asking. Is the lack of clarity just being lazy on your part? ;-)
>>
>> List the version to 4 decimal places when responding.
>> --
>> Daniel Morgan
>> Puget Sound Oracle Users Group
>
> I think he means this:
>
> SQL> select user as my_user from dual
> 2 where my_user = user;
> where my_user = user
> *
> ERROR at line 2:
> ORA-00904: "MY_USER": invalid identifier
If he does then I doubt it is any different in any other RDBMS.
No product accepts a table_name as a column name of which I am aware.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Fri Oct 06 2006 - 15:55:17 CDT
