Re: How to use UPPER in a view ??? (Scalar Character Functions)

jens_at_deutschware.com (Jens U. Veigel) wrote:

You need to give a column name to the expression eg select UPPER (slot_num) fred, UPPER (apn_pb_num) martha

You can then use select fred, martha from stencil_p .
>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
>
>

Thomas R Skinner
Allgas Energy Ltd
('Fixed in the next release') Received on Tue Apr 01 1997 - 00:00:00 CST