create or replace function f_name return varchar2 is
r_value varchar2(1000);
begin
for v in (select name from test) loop
r_value:=r_value||v||',';
end loop;
return substr(r_value, 1, length(r_value-1));
end;
r_value varchar2(1000);
begin
for v in (select name from test) loop
r_value:=r_value||v||',';
end loop;
return substr(r_value, 1, length(r_value-1));
end;
from
(select test.name,rownum rn)
start with rn=1
connect by prior rn=rn-1
r_value varchar2(2000);
begin
r_value:='';
for v in (select name from test) loop
r_value:=r_value||v||',';
end loop;
return left(r_value, length(r_value-1));
end f_name;
select f_name() from dual;
from
(select table.name,rownum num)
start with num=1
connect by prior num=num-1
有:aaa|bbb|ccc|ddd|eee
如何分割成:
aaa
bbb
ccc
ddd
eee
?请教大家了!!