Oracle将查询结果存储到变量中
set serveroutput on
declare
a varchar2(10);
b varchar2(20);
begin
select groupname,projectname into a,b from trp_advp_copy where id = 942371;
dbms_output.put_line(a||'---'||b);
end;
set serveroutput on
declare
a varchar2(10);
b varchar2(20);
begin
select groupname,projectname into a,b from trp_advp_copy where id = 942371;
dbms_output.put_line(a||'---'||b);
end;