This shows you the differences between two versions of the page.
kurs:procedure [2014/09/10 21:22] |
kurs:procedure [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | 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; | ||