oracle的编写一个触发器当任何时候某个部门从dept1中删除就删除emp1表中该部门的所有雇员

代码怎么写啊
2025-03-25 22:30:52
推荐回答(1个)
回答1:

create or replace trigger mytrigger
after delete on dept1
for each row
begin
delete from emp1 where deptno=:old.deptno;
end;
/