Oracle中record变量的使用

--声明record变量之前必须先定义
set serveroutput on
declare
  type mytype is record (
    a trp_advp_copy.groupname%type,
    b trp_advp_copy.projectname%type
  );
  c mytype;
begin
  select groupname,projectname into c from trp_advp_copy where id = 942371;
  dbms_output.put_line(c.a||'---'||c.b);
end;