Re: Help with Trigger

Why not ?

create trigger x before delete on my_table for each row begin

    insert into my_dup_table values(:old.col1, :old.col2); end;
/

This would work fine.

Regards,

Marc Mazerolle

Database Generation Ltd. wrote:

> Dear friends,
>
> Is it possible (and if it possible - how) to create the trigger BEFORE
> delete that will copy the record before delete it into another table
> with the same structure?
>
> Thank you very much in advance.
> Eugene
Received on Tue Mar 09 1999 - 13:35:02 CST