现遇到问题:
表中的记录为
ID name amount
1 a,b,c 10
转换成为
ID name amount
1 a 10
1 b 10
1 c 10
select * from aa ;
sql:
select id,
nvl(substr(name,instr(name,',',1,lvl)+1,instr(name,',',1,lvl+1)-instr(name,',',1,lvl)-1),' ') name,
amount
from (
select id,
lvl,
',' || name || ',' name,
amount
from aa a,
(select level lvl
from dual
connect by level <=
(select max(length(name) - length(replace(name, ','))) + 1
from aa)) b)
where substr(name,instr(name,'