Question

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

代码怎么写啊

Answer 1

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