CREATE OR REPLACE TRIGGER trg_A
after update
of aa
ON a
referencing new as new old as old
for each row
declare
begin
if :new.aa<>:old.aa then
update B set aa=:new.aa where A.XX=B.XX;
end if;
exception
when others then
null;
end trg_A;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024