select aid,aname,getbname(aid) from a where aid = '1';create or replace function getbname (v_id varchar2) return varchar2 is v_id varchar2(10); v_bname varchar2(50);cursor crgetid is select bname from b where aid = v_id ; begin open crgetid; LOOP fetch crgetid into v_id; EXIT WHEN crgetid%NOTFOUND ; v_bname := v_bname || ',' || v_id ; End Loop; close crgetid; return substr(v_bname,2); end;
from a
where aid = '1';create or replace function getbname (v_id varchar2)
return varchar2
is
v_id varchar2(10);
v_bname varchar2(50);cursor crgetid is
select bname
from b
where aid = v_id ;
begin
open crgetid;
LOOP
fetch crgetid into v_id;
EXIT WHEN crgetid%NOTFOUND ;
v_bname := v_bname || ',' || v_id ;
End Loop;
close crgetid;
return substr(v_bname,2);
end;