日期:2014-05-17 浏览次数:20843 次
select name,regexp_substr(id,'[^,]+',1,n) from test_a left join (select level,rownum n from dual connect by level < 10) on 1=1 where regexp_substr(id,'[^,]+',1,n) is not null