Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

HR ADD_JOB_HISTORY (procedure)

RSS
Modified on 2011/08/27 12:09 by wikibot Categorized as Uncategorized

wikibot

ProcedureHR.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;

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.