Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Column alias- Can't do this?

Column alias- Can't do this?

From: Antonio Pascual <apa_at_jerez.micro.lucent.com>
Date: Tue, 24 Aug 1999 10:11:23 +0200
Message-ID: <7ptk3e$5ku@nntpa.cb.lucent.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US