create or replace function get(p_code in varchar2)
return varchar2 is
Result varchar2(100);
cursor rad_cursor is
select Description from tabname
where code=p_code ;
v_count Number;
begin
v_count:=0;
for v_sor in rad_cursor loop
if v_count=0 then
Result:=v_sor.Description;
v_count:=v_count+1;
else
Result:=Result||','||v_sor.Description;
end if;
end loop;
return(Result);
end get;
/select code,get(code) from tabname group by code;
return varchar2 is
Result varchar2(100);
cursor rad_cursor is
select Description from tabname
where code=p_code ;
v_count Number;
begin
v_count:=0;
for v_sor in rad_cursor loop
if v_count=0 then
Result:=v_sor.Description;
v_count:=v_count+1;
else
Result:=Result||','||v_sor.Description;
end if;
end loop;
return(Result);
end get;
/select code,get(code) from tabname group by code;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货