create or replace function get(p_seq_no in varchar2) return varchar2 is
Result varchar2(100);
cursor rad_cursor(v_seq_no varchar2) is
select zzz,yyy,xxx from table2
where table1_seq_no=v_seq_no;
begin
for v_sor in rad_cursor(p_seq_no) loop
Result:=Result||v_sor.zzz||v_sor.yyy||v_sor.xxx;
end loop;
return(Result);
end get;
/select seq_no,aaa,bbb,get(seq_no) ccc from table1;
Result varchar2(100);
cursor rad_cursor(v_seq_no varchar2) is
select zzz,yyy,xxx from table2
where table1_seq_no=v_seq_no;
begin
for v_sor in rad_cursor(p_seq_no) loop
Result:=Result||v_sor.zzz||v_sor.yyy||v_sor.xxx;
end loop;
return(Result);
end get;
/select seq_no,aaa,bbb,get(seq_no) ccc from table1;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货