可以将 bjdm 换成 ‘01,02,03,04‘ , valueWeekInfo 换成dual 查看结果
Oracle 正则 一行转多行
标签：
Oracle 正则 一行转多行
REGEXP_SUBSTR(bjdm||‘,‘, ‘[^,]+‘, 1, LEVEL, ‘i‘) AS STR,bjdm FROM valueWeekInfo
CONNECT BY LEVEL <= LENGTH(bjdm) - LENGTH(REGEXP_REPLACE(bjdm, ‘,‘, ‘‘)) + 1;