Re: Functions and where vs. group-by inconsistency

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 Received on Fri Oct 06 2006 - 14:55:35 CDT