--%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;
Oracle %type 使用实例
最新推荐文章于 2023-11-10 15:55:28 发布