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

Thomas R Skinner wrote:
>
> 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 !!
> >

---
select UPPER (slot_num) "column_alias", UPPER (apn_pb_num)
"column_alias2"

This is how to rename the column heading.