SELECT REGEXP_SUBSTR(kdids, '[^,]+', 1, rownum) as id
FROM DUAL
CONNECT BY ROWNUM <=
LENGTH(kdids) - LENGTH(REPLACE(kdids, ',', '')) + 1
转载于:https://my.oschina.net/javawdw/blog/210402
SELECT REGEXP_SUBSTR(kdids, '[^,]+', 1, rownum) as id
FROM DUAL
CONNECT BY ROWNUM <=
LENGTH(kdids) - LENGTH(REPLACE(kdids, ',', '')) + 1
转载于:https://my.oschina.net/javawdw/blog/210402