Re: Help with Trigger

The following example is a "before" trigger rather than an "after" .

Assume the table is testtrigger and it has fields called field1 and and field2.

create or replace trigger testtrigger_tg before insert or update on testtrigger
for each row
begin

   :new.field5 := :new.field1;
end;

Frank Hubeny

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.
  Received on Mon Aug 28 2000 - 23:39:45 CDT