Oracle %type 使用实例

--%type 使用实例
declare   
  type type_org_record is record(  
     v_name    table_name.id%type,
     v_parent  table_name.xingming%type,
     v_SHENFZHENGHAO table_name.shenfzhenghao%type,
     v_ZHUANGTAI table_name.zhuangtai&type
     );
     v_record  type_org_record;
begin  
  select id,xingming,shenfzhenghao,ZHUANGTAI into v_record from table_name yh
  where yh.id = 1111;
  dbms_output.put_line('部门名称：' || v_record.v_name);  
  dbms_output.put_line('上级部门编码：' || to_char(v_record.v_parent)); 
  dbms_output.put_line('上级部门编码：' || to_char(v_record.v_SHENFZHENGHAO)); 
  dbms_output.put_line('上级部门编码：' || to_char(v_record.v_ZHUANGTAI)); 
end;