| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to use UPPER in a view ??? (Scalar Character Functions)
In article <333952eb.93514997_at_news.aud.alcatel.com>, jens_at_deutschware.com (Jens U. Veigel) writes:
|> 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 !!
This means what it says :-) You have to have an alias for it. The reason why is because a view must have valid column names for each column. You could do it with something like:
CREATE VIEW stencil_p as
select UPPER (slot_num) slot_num, UPPER (apn_pb_num) apn_pb_num, UPPER (apn_pba_num) apn_pba_num, UPPER (pb_alias_num) pb_alias_num, UPPER (pba_alias_num) pba_alias_num, UPPER (dsr) dsr, thickness, UPPER (work_holder) work_holder
from ssd.stencil
where requirements ='P'
and status = 'R'
for example. You may want to pick different alias names. If you didn't have column aliases, you couldn't describe the view.
|>
|> PS: Is there a way to implement a case restriction in a combobox ?
|>
|> Thanks
|> Jens
|> jens_at_deutschware.com
|>
|>
 |
 |