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 ...) |
|||
| (3 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> | ||
| − | PROCEDURE add_job_history | + | CREATE OR REPLACE PROCEDURE add_job_history |
( p_emp_id job_history.employee_id%type | ( p_emp_id job_history.employee_id%type | ||
, p_start_date job_history.start_date%type | , p_start_date job_history.start_date%type | ||
Latest revision as of 11: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;
