请在数据库中添加两个触发器：

1：删除表staff_userinfo中的用户时，同时删除staff_userrole中用户对应的角色；

2：删除表staff_role中的角色时，同时删除staff_rolemodule中角色对应的模块。

错误：

1.create or replace trigger delete_trigger1

after delete on staff_userinfo for each row

begin

delete from staff_userrole where staff_userinfo.userid=staff_userrole.userid;

end;

2.create or replace trigger delete_trigger2

after delete on staff_role for each row

begin

delete from staff_rolemodule where staff_role.roleid=staff_rolemodule.roleid;

end;

正确：

1.create or replace trigger delete_trigger1

after delete on staff_userinfo

for each row

begin

if deleting then

delete staff_userrole

where userid=:old.userid;

end if;

end;

/

2.create or replace trigger delete_trigger2

after delete on staff_role

for each row

begin

if deleting then

delete staff_rolemodule

where roleid=:old.roleid;

end if;

end;

/

ITPub博客

Oracle触发器级联删除