Re: Help with Short Trigger

Jannette wrote:
>
> Please help me with this short Trigger, I just can't make it work:
> After each insert or update on Field_1, I want the Trigger to write the
> new value of Field_1 to Field_5 (of the same table).
>
> Thanks a lot !
>
> Jannette
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

create or replace trigger set_1_to_5
before insert or update on my_table
for each row
begin
  :new.field1 := :new.field5;
end;

or thereabouts...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse