create or replace trigger trig_on_A after insert or update or delete on A for each row begin if inserting then insert into B values(:new.userid,:new.department); end if;
if updating(userid,department) then update B set userid=:new.userid,:new.department where userid=:old.userid; end if; if deleting then delete from B where userid=:old.userid end if; end trig_on_A;
update B set userid=:new.userid,:new.department where userid=:old.userid; 应为: update B set userid=:new.userid,department=:new.department where userid=:old.userid;
after insert or update or delete on A
for each row
begin
if inserting then
insert into B values(:new.userid,:new.department);
end if;
if updating(userid,department) then
update B set userid=:new.userid,:new.department where userid=:old.userid;
end if; if deleting then
delete from B where userid=:old.userid
end if;
end trig_on_A;
应为:
update B set userid=:new.userid,department=:new.department where userid=:old.userid;