SELECT REGEXP_SUBSTR(materialTypeCodes, '[^,]+', 1, rownum)FROM DUAL
CONNECT BY ROWNUM <=LENGTH(materialTypeCodes) - LENGTH(REPLACE(materialTypeCodes, ',', NULL)) + 1
orcal把用逗号隔开的数据转为列
最新推荐文章于 2021-04-04 10:19:43 发布
SELECT REGEXP_SUBSTR(materialTypeCodes, '[^,]+', 1, rownum)FROM DUAL
CONNECT BY ROWNUM <=LENGTH(materialTypeCodes) - LENGTH(REPLACE(materialTypeCodes, ',', NULL)) + 1