Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Column alias- Can't do this?
SQL> r
1 select data, avg(is_number(value)) as col1
2 from apatest
3 where col1 is not null
4* group by dato
where col1 is not null
*
ERROR at line 3:
ORA-00904: invalid column name
I Can't a column alias in the where clause?
regards,
Antonio. Received on Tue Aug 24 1999 - 03:11:23 CDT