Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: How to use UPPER in a view ??? (Scalar Character Functions)

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

From: Maikel Alderhout <0alderhout01_at_almere.flnet.nl>
Date: 1997/03/29
Message-ID: <333CD5C7.235@almere.flnet.nl>#1/1

Hi Jens,

Try to use column aliases in the view creation like;

upper(slot_num) slot_num, upper(apn_pb_num) apn_pb_num ...etc etc

Maikel Received on Sat Mar 29 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: ttran_at_ssofa.com: "PL/SQL cursor"
Previous message: Vijay Vardhineni: "Re: How to use UPPER in a view ??? (Scalar Character Functions)"
In reply to: Jens U. Veigel: "How to use UPPER in a view ??? (Scalar Character Functions)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US