Difference between revisions of "HR.ADD JOB HISTORY (procedure)"
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| − | | ''' | + | | '''Procedure |
| HR.ADD_JOB_HISTORY | | HR.ADD_JOB_HISTORY | ||
| − | |||
|} | |} | ||
| − | + | === Source === | |
<pre> | <pre> | ||
CREATE OR REPLACE PROCEDURE add_job_history | CREATE OR REPLACE PROCEDURE add_job_history | ||
Latest revision as of 10:33, 27 August 2011
wikibot[edit]
| Procedure | HR.ADD_JOB_HISTORY |
Source[edit]
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;
