Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic UPPER conversion on an Insert
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