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