create function get_value(p_name in varchar2) return varchar2 as str varchar2(100); cursor t_sor is select name from table1 where name=p_name; begin for v_sor in t_sor loop str:=str||v_sor.name; end loop; return str; end; / select name,get_value(name) from table1 group by name;
什么意思??????能详细点吗?????
return varchar2
as
str varchar2(100);
cursor t_sor is
select name from table1 where name=p_name;
begin
for v_sor in t_sor loop
str:=str||v_sor.name;
end loop;
return str;
end;
/
select name,get_value(name) from table1 group by name;