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

Hai,
 While creating view, if you have any selected column have convert funcs. such as
Upper,Substr ,you should give a explicit column alias (eg. UPPER(slot_num) slnum). Then you would not have the problem. Some installations depending upon the versions it might work without any column alias but Oracle says ,now that is an undocumented feature. So better to have a colum alias whenever you have convert
funct. on the selected columns. Hope that it helps you...

Perry.

Jens U. Veigel <jens_at_deutschware.com> wrote in article <333952eb.93514997_at_news.aud.alcatel.com>...
> 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
Received on Wed Mar 26 1997 - 00:00:00 CST