Difference between revisions of "HR.ADD JOB HISTORY (procedure)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | HR.ADD_JOB_HISTORY |- |} <pre> PROCEDURE add_job_history ( p_emp_id ...) |
(No difference)
|
Revision as of 18:07, 2 May 2009
wikibot
procedure | HR.ADD_JOB_HISTORY |
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;