Re: UPPERCASE Trigger

Duane F. Vermeire <dfverme_at_sandia.gov> wrote:
: Is there a way using a trigger or something else to force the oracle
: tables to put all data in uppercase?

Yes, create trigger on insert and update for each row and in trigger body use something like this

:new.column_name := upper ( :new.column_name );

do this for all columns you have in table.

        Starous Received on Thu Aug 24 2000 - 12:07:49 CDT