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;
看看是否对你对你有帮助,
begin
hong(4000,morebest);
end;