How should I start

[RycherX]

I have 2 tables

table1 fields
--------------
quote
status

I want to set up a table

table2 fields
---------------
quote
status
date


In the event that table1.status changes, I want a transaction log in table2. Any suggestions to point to the right direction?

 

[feherke]

Hi

create or replace trigger table1_modify
before update of status on table1
for each row
begin
  insert into table2 (quote,status,"date") values (:new.quote,:new.status,sysdate);
end;

Feherke.

http://rootshell.be/~feherke/