Welcome Guest, you are in: <root> • Login

Page History: HR ADD_JOB_HISTORY (procedure)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 07:58

wikibot ¶

Procedure

HR.ADD_JOB_HISTORY

Source ¶

CREATE OR REPLACE PROCEDURE add_job_history
  (  p_emp_id          job_history.employee_id%type
   , p_start_date      job_history.start_date%type
   , p_end_date        job_history.end_date%type
   , p_job_id          job_history.job_id%type
   , p_department_id   job_history.department_id%type
   )
IS
BEGIN
  INSERT INTO job_history (employee_id, start_date, end_date,
                           job_id, department_id)
    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;

References ¶

Dependency Type	Object Type	Referenced Object
Insert	Table	HR.JOB_HISTORY