create or replace procedure ptest as strname varchar2(30); str varchar2(1000); strid varchar2(10); cursor cur is select total,month from AB; begin str:=''; open cur; loop fetch cur into strid,strname; exit when cur%notfound; str:=str||strname||','; end loop; str:=substr(str,1,length(str)-1); dbms_output.put_line(str); end;
1.oracle版本
2.问题描述清楚
3.给出部分数据
4.给出想要结果
......
strname varchar2(30);
str varchar2(1000);
strid varchar2(10);
cursor cur is select total,month from AB;
begin
str:='';
open cur;
loop
fetch cur into strid,strname;
exit when cur%notfound;
str:=str||strname||',';
end loop;
str:=substr(str,1,length(str)-1);
dbms_output.put_line(str);
end;
经典教程 LZ不要错过