create or replace trigger tg_a before update of a1 on table_A for each row begin insert into talbe_B(a_col1,a_col1_new,a_col2,a_col2_new) values(:old.col1,:new.col2,:old.col2,:new.col2); end;
create or replace trigger tg_a before update of a1 on table_A for each row begin insert into talbe_B(a_col1,a_col1_new,a_col2,a_col2_new) values(:old.col1,:new.col2,:old.col2,:new.col2); end;
before update of a1 on table_A
for each row
begin
insert into talbe_B(a_col1,a_col1_new,a_col2,a_col2_new)
values(:old.col1,:new.col2,:old.col2,:new.col2);
end;
before update of a1 on table_A
for each row
begin
insert into talbe_B(a_col1,a_col1_new,a_col2,a_col2_new)
values(:old.col1,:new.col2,:old.col2,:new.col2);
end;