복합 데이터타입 - %rowtype 데이터형 기본 실습

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

--Anonymous Procedure

--%rowtype

set serveroutput on

 

declare

 

             v_employee employees%rowtype;

 

begin

 

             select employee_id, last_name

             into v_employee.employee_id, v_employee.last_name

             from employees

             where employee_id = 196;

 

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

             dbms_output.put_line('변수2 : ' || v_employee.last_name);

 

end;

/

 

set serveroutput off

 

 

실행

@c:\oracle\plsqlex03