Re: before insert or update trigger that inserts all upper case

On Mon, 11 Jul 2005 14:50:42 -0400, Rob Williamson <robw_at_physics.umd.edu> wrote:

>Does anyone have a before insert or update trigger already written
>that inserts or updates only upper case charaters into a column of a
>table. I have been seardhing some of my books but can not find one.
>If any one has one they have been using and wouldn't mind sharing that
>would be great.
>Rob

create or replace trigger foo_briu before insert or update on blah before each row is
begin
:new.<affected_column> := upper(:new.<affected_column>); end;
/

And that's all there is to it!

Homework!!!

--
Sybrand Bakker, Senior Oracle DBA