create or replace trigger
before update or delete or insert on A
for each row
begin
--当A更新时触发
if updating then
update B
set b2 = ....自定义,例如::new.a2
where B.id = :new.id;
end if;
--当A删除时触发
if deleting then
delete from B
where B.id = :old.id;
end if; --当A插入时触发
if inserting then
insert into B
(id,b2) values (:new.id,a2);
end if;
end;
before update or delete or insert on A
for each row
begin
--当A更新时触发
if updating then
update B
set b2 = ....自定义,例如::new.a2
where B.id = :new.id;
end if;
--当A删除时触发
if deleting then
delete from B
where B.id = :old.id;
end if; --当A插入时触发
if inserting then
insert into B
(id,b2) values (:new.id,a2);
end if;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货