복합 데이터타입 - PL/SQL Table 데이터형 기본 실습

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

--Anonymous Procedure

--Table : 일차원배열

set serveroutput on

 

declare

             --type employee_id_table is table of number(4)

             --index by binary_integer;

 

             type employee_id_table is table of employees.employee_id%type

             index by binary_integer;

 

             type last_name_table is table of varchar(20)

             index by binary_integer;

 

             employee_id_tab employee_id_table;

             last_name_tab last_name_table;

 

begin

             select employee_id, last_name

             into employee_id_tab(1), last_name_tab(1)

             from employees

             where employee_id = 100;

 

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

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

 

end;

/

 

set serveroutput off

 

 

실행

@c:\oracle\plsqlex05