#副標= Oracle 10g開發專題(6)
#大標=利用JDeveloper 10g管理資料庫物件（下）
#眉標=Oracle 10g
#作者=何致億



-------------------box 程式1-------------------
TRIGGER "HR"."EMP_DELETE" AFTER DELETE ON "HR"."EMPLOYEES" 
REFERENCING OLD AS OLD NEW AS NEW 
FOR EACH ROW 
BEGIN
  NULL;
END;
----------------------------end------------------------


----------------------box 程式2------------------------
TRIGGER "HR"."EMP_DELETE" AFTER DELETE ON "HR"."EMPLOYEES" 
REFERENCING OLD AS OLD NEW AS NEW 
FOR EACH ROW 
BEGIN
  INSERT INTO retired_emp(employee_id, first_name, last_name,
                          email, hire_date, retired_date,
                          job_id, department_id)
  VALUES(:OLD.employee_id, :OLD.first_name, :OLD.last_name,
         :OLD.email, :OLD.hire_date, SYSDATE,
         :OLD.job_id, :OLD.department_id);
END;
-----------------------end-------------------------