create or replace function get(p_name in varchar2) return varchar2 is Result varchar2(50);
cursor rad_cursor(v_name varchar2) is select attrs from a where name=v_name;
begin Result:=''; for v_sor in rad_cursor(p_name) loop Result:=Result||v_sor.attrs; end loop; return(Result); end get; /select name,get(name) attrs from a group by name;
用pl/sql块吧
我想不出什么办法使用pl/sql
return varchar2
is
Result varchar2(50);
cursor rad_cursor(v_name varchar2) is
select attrs from a
where name=v_name;
begin
Result:='';
for v_sor in rad_cursor(p_name) loop
Result:=Result||v_sor.attrs;
end loop;
return(Result);
end get;
/select name,get(name) attrs from a group by name;