create function get_value(p_id in varchar2)
return varchar2
as
str varchar2(20);
cursor t_sor is
select sf from b where id=p_id;
begin
for v_sor to t_sor do
str:=str||','||v_sor.sf;
end loop;
return str;
end;
/
select id,mc||get_value(id) from a;
return varchar2
as
str varchar2(20);
cursor t_sor is
select sf from b where id=p_id;
begin
for v_sor to t_sor do
str:=str||','||v_sor.sf;
end loop;
return str;
end;
/
select id,mc||get_value(id) from a;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货