ITPub博客

select * from   (     with temp as     (select '2011-01,2011-02' text from dual)     select regexp_substr(text,'',1,rn) text from temp t1,     (select level rn from dual connect by rownum <= (select length(text)-length(replace(text,',',''))+1 from temp)) t2 ) aa