CREATE OR REPLACE TRIGGER UPDATE_biao2_tri after update on 表1 for each row begin if :new.字段A != :old.字段A then update 表2 set 字段B = :new.字段A where .........(看具体怎么加条件) end if; end UPDATE_biao2_tri; /
create or replace trigger tri1 after update on table1 for each row begin update table2 set b=:new.a where ...; end tri1;
after update on 表1
for each row
begin
if :new.字段A != :old.字段A then
update 表2 set 字段B = :new.字段A where .........(看具体怎么加条件)
end if;
end UPDATE_biao2_tri;
/
after update on table1
for each row
begin
update table2 set b=:new.a where ...;
end tri1;