User Tools

Site Tools


kurs:p_indexby_scalar

Differences

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

Link to this comparison view

kurs:p_indexby_scalar [2014/09/10 21:22] (current)
Line 1: Line 1:
 +<​code>​
 +PROCEDURE P_INDEXBY_SKCALAR
 +  (v_last_name in varchar)
 +  IS
 +  TYPE emp_name_table_type IS table of
 +    employees.last_name%type
 +    index by binary_integer;​
 +  emp_name_table emp_name_table_type;​
 +  v_ind number(30);
 +BEGIN
 +   ​select employee_id
 +   into v_ind
 +   from employees
 +   where lower(v_last_name) = lower(last_name);​
  
 +   ​emp_name_table(v_ind) := v_last_name;​
 +   ​dbms_output.put_line(v_ind||',​ '​||emp_name_table(v_ind)||',​ '​||emp_name_table.count||'​ Obj.'​);​
 +END;
 +</​code>​
kurs/p_indexby_scalar.txt ยท Last modified: 2014/09/10 21:22 (external edit)