how to automatic update a table using a trigger?

[hedub]

Hi, i am a newbie when it comes to pl/sql and programming triggers and procedures etc.

I have to tables, lets call them Tab1 and Tab2. I wish that the trigger will execute and update Tab2 after insert on Tab1. Most of the attributes are the same in Tab1 as in Tab2. Tab2 is for statistics. How do I do this? I know how to trigger a table when it comes to the same table, but not from one table to another. Can anyone help me? pls tell me if you want more info. Thanks.

 

[sem]

Just add an appropriate insert and/or update statements using :new or ld modifiers. Suppose you have tables:

A(a varchar2(10))
A_JN(a_old varchar2(10),a_new varchar2(10), change_date date)

You may place the following code into row-level trigger on A:

insert into A_JN valuesold.a, :new.a, sysdate);
Regards, Dima

 

[hedub]

Thanks!