============<box>=================
TRIGGER "SCOTT"."EMP_DELETE" 
AFTER DELETE ON "SCOTT"."EMP" 
FOR EACH ROW
BEGIN
  NULL;
END;
==============<end>===================



」」」」」」」」」」」」」」」》box>================
TRIGGER "SCOTT"."EMP_DELETE" 
AFTER DELETE ON "SCOTT"."EMP" 
FOR EACH ROW 
BEGIN
  INSERT INTO retired_emp(empno, ename, job, mgr, hiredate, 
                                                retiredate, sal, comm, deptno)
  VALUES(:OLD.empno, :OLD.ename, :OLD.job, :OLD.mgr, :OLD.hiredate,
                  SYSDATE, :OLD.sal, :OLD.comm, :OLD.deptno)
END;
===================<end>===========================