복합 데이터형 - PL/SQL Table of Record 데이터형 기본 실습

plsqlex06.sql (경로 : c:\oracle\)

--Anonymous Procedure

--Table of Record

set serveroutput on

 

declare

             type employee_table is table of employees%rowtype

             index by binary_integer;

 

             employee_tab employee_table;

 

begin

             select employee_id, last_name

             into employee_tab(1).employee_id, employee_tab(1).last_name

             from employees

             where employee_id = 100;

 

             dbms_output.put_line('변수 : ' || employee_tab(1).employee_id);

             dbms_output.put_line('변수 : ' || employee_tab(1).last_name);

 

end;

/

 

set serveroutput off

 

 

실행

@c:\oracle\plsqlex06