SELECT REGEXP_SUBSTR(bjdm||‘,‘, ‘[^,]+‘, 1, LEVEL, ‘i‘) AS STR,bjdm FROM valueWeekInfo CONNECT BY LEVEL <= LENGTH(bjdm) - LENGTH(REGEXP_REPLACE(bjdm, ‘,‘, ‘‘)) + 1;
可以将 bjdm 换成 ‘01,02,03,04‘ , valueWeekInfo 换成dual 查看结果
原文：http://www.cnblogs.com/gxivwshjj/p/4793849.html