HR - HR.UPDATE_JOB

Description

update_job_history AFTER UPDATE OF job_id, department_id ON employees FOR EACH ROW

Trigger properties

name	value
name	HR.UPDATE_JOB_HISTORY
base object type	TABLE
parent	EMPLOYEES
type	AFTER EACH ROW
event	UPDATE
action type	PL/SQL
referencing names	REFERENCING NEW AS NEW OLD AS OLD
status	ENABLED

Dependency graph

ADD_JOB_HISTORYEMPLOYEESUPDATE_JOB_HISTORY

Objects that HR.UPDATE_JOB_HISTORY depends on

name	object type	level
ADD_JOB_HISTORY	stored procedure	1
JOB_HISTORY	table	2
EMPLOYEES	table	1

Code

  CREATE OR REPLACE TRIGGER "HR"."UPDATE_JOB_HISTORY" 
  AFTER UPDATE OF job_id, department_id ON employees
  FOR EACH ROW
BEGIN
  add_job_history(:old.employee_id, :old.hire_date, sysdate,
                  :old.job_id, :old.department_id);
END;
ALTER TRIGGER "HR"."UPDATE_JOB_HISTORY" ENABLE

HR - triggers - HR.UPDATE_JOB_HISTORY

Description

Trigger properties

Dependency graph

Objects that HR.UPDATE_JOB_HISTORY depends on

Code