-- Created on 2023/8/31 by GX
declare
-- Local variables here
--定义一个记录类型
type emp_record is record(
v_id varchar2(32),--pfm_cloud.op_as_ad_sa_cust%type;
v_res_id varchar(32)
);
--声明一个自定义记录类型的变量
v_emp_record emp_record;
begin
-- Test statements here
select id,res_id into v_emp_record from op_as_ad_sa_cust where rownum = 1;
dbms_output.put_line(v_emp_record.v_id||'123'||v_emp_record.v_res_id);
end;