Re: UPPERCASE Trigger

Hallo Duane!

Try this:

create or replace
trigger trig_uppercase
on table tab_in_uppercase
before insert or update
for each row
begin

   :NEW.column_name1 := upper(:NEW.column_name1);    :NEW.column_name2 := upper(:NEW.column_name2);    ...
end;

Hope this helps,
Stefan.

Duane F. Vermeire <dfverme_at_sandia.gov> schrieb in im Newsbeitrag: 39A55458.77B5BD76_at_sandia.gov...
> Is there a way using a trigger or something else to force the oracle
> tables to put all data in uppercase?
Received on Thu Aug 24 2000 - 12:40:50 CDT