User Tools

Site Tools


kurs:insert_salary

Differences

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

Link to this comparison view

kurs:insert_salary [2014/09/10 21:22] (current)
Line 1: Line 1:
 +<​code>​
 +PROCEDURE PC_INSERT_SALARY
 +    IS
 +   type emp_salary is table of
 +   ​employees%ROWTYPE
 +   index by binary_integer;​
  
 +    first_index number(30);
 +    last_Index number(30);
 +   
 +   ​emp_table emp_salary;
 +   i_Ind number;
 +BEGIN
 +    select min(employee_id),​ max(employee_id)
 +        into first_index,​ last_Index
 +        from employees;
 +
 +    FOR i_Ind IN first_index..last_index
 +    Loop
 +        select * into emp_table(i_ind) from employees where employee_id = i_Ind;
 +    end loop;
 +    ​
 +    i_Ind := emp_table.first();​
 +    ​
 +    for i_Ind in emp_table.first..emp_table.last
 +    loop
 +        insert into pc_employee_bonus (employee_id,​ last_name, salary)
 +            values (emp_table(i_Ind).employee_id,​
 +                emp_table(i_Ind).last_name,​
 +                emp_table(i_Ind).salary);​
 +    end loop;
 +    ​
 +END; -- Procedure
 +</​code>​
kurs/insert_salary.txt ยท Last modified: 2014/09/10 21:22 (external edit)