User Tools

Site Tools


kurs:ramos

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

kurs:ramos [2014/09/10 21:22] (current)
Line 1: Line 1:
 +<​curse>​
  
 +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;​
 +</​curse>​
kurs/ramos.txt ยท Last modified: 2014/09/10 21:22 (external edit)