Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to use UPPER in a view ??? (Scalar Character Functions)
Hey SQL Gurus !
The select statement works. When I try to do it in a view like below,
CREATE VIEW stencil_p as
select UPPER (slot_num), UPPER (apn_pb_num), UPPER
(apn_pba_num), UPPER (pb_alias_num), UPPER (pba_alias_num), UPPER
(dsr), thickness, UPPER (work_holder)
from ssd.stencil where requirements ='P' and status = 'R'
I get the following error:
select UPPER (slot_num), UPPER (apn_pb_num) ........
*
ORA-00998: must name this expression with a column alias
What does it mean ??? Thanks for taking the time to read it !!
PS: Is there a way to implement a case restriction in a combobox ?
Thanks
Jens
jens_at_deutschware.com
Received on Wed Mar 26 1997 - 00:00:00 CST