oracle拆分逗号分隔字符串 实现拆分字符串

SELECT REGEXP_SUBSTR(‘a,b,c,d’, ‘[^,]+’, 1, rownum)
FROM DUAL
CONNECT BY ROWNUM <= LENGTH(‘a,b,c,d’) - LENGTH(REPLACE(‘a,b,c,d’, ‘,’, ‘’)) + 1