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
oracle拆分逗号分隔字符串 实现拆分字符串
最新推荐文章于 2024-06-25 17:19:55 发布
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