Re: How would I use Upper( ) function?

create or replace trigger foo_bri before insert or update on foo for each row
begin
:new.col1 := upper(:new.col1);
:new.col2 := upper(:new.col2);
-- etc...
end;
/

For further details please refer to the application developers guide!

Regards,

Sybrand Bakker, Oracle DBA

"John Andersen" <johna_at_digisys.com (change com to net)> wrote in message news:wVV06.410$SJ2.232034_at_feed.centurytel.net...
> Hi All,
>
> I am implementing a canned Help Desk application using Oracle as the
> back-end. I have created the Schema, Tablespaces, and Tables,
 Constraints,
> etc.
>
> What I need to do now is make every record that is inserted (or updated)
 be
> in UPPER CASE, even if the user types it in lower case.
>
> Would this be done by using a trigger, using Oracle's Upper( ) function??
> If so, please give some details.
>
> Thanks in advance!!
>
> JA
>
>
Received on Sat Dec 23 2000 - 00:54:34 CST