create or replace function get(p_id in varchar2)
return varchar2 is
Result varchar2(100);
cursor rad_cursor(v_id varchar2) is
select distinct name from student
where id=v_id ;
begin for v_sor in rad_cursor(p_id) loop
Result:=Result||v_sor.name;
end loop;
return(Result);
end get_book;
/select id,get(id) from student group by id;
return varchar2 is
Result varchar2(100);
cursor rad_cursor(v_id varchar2) is
select distinct name from student
where id=v_id ;
begin for v_sor in rad_cursor(p_id) loop
Result:=Result||v_sor.name;
end loop;
return(Result);
end get_book;
/select id,get(id) from student group by id;
以前很多人问过这种问题
你一定要用一条语句?用函授或过程不行?