伪代码:
create or replace t1_bu_trg on T1 for each row
declare
begin
if :new.ab <> :old.ab then
update t2 set ab = :new.ab
where ab = :old.ab;
update t3 set ab = :new.ab
where ab = :old.ab;
end if;
exception
when others then
raise_application_error(-20001,sqlerrm);
end;
/