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: Automatic UPPER conversion on an Insert

Re: Automatic UPPER conversion on an Insert

From: Victor Yu Valenzuela <victorv_at_fastmail.i-next.net>
Date: Fri, 22 Oct 1999 13:38:05 +0800
Message-ID: <7uoteh$e5d$1@newton3.pacific.net.sg>


no way .. except using triggers... no other option..

Sam wrote in message <7untl9$rb$1_at_ffx2nh3.news.uu.net>...
>Yup, that was the obvious One. Is there any way to Enforce this conversion
>at the Column defn ( User defined fns ? )
>
>Thx
>
>-Thiru
>Peter Okhiria <peter.okhiria_at_mci.com> wrote in message
>news:380F2465.3F240811_at_mci.com...
>> why not use the upper() function to do the conversion at the point of
>> insertion/update...
>>
>> Sam wrote:
>>
>> > Hi all
>> > Is there any way to automatically convert the Inserted Value into UPPER
>case
>> > ?
>> > I want to avoid Triggers and am looking for something like Column defn
>or
>> > Constraint ..
>> >
>> > Thx
>> >
>> > Sam
>>
>>
>>
>
>
Received on Fri Oct 22 1999 - 00:38:05 CDT

Original text of this message

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