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