‘1,2,3’为需要分割的字符串
SELECT REGEXP_SUBSTR('1,2,3', '[^,]+', 1, rownum)
from dual
connect by rownum <=
LENGTH('1,2,3') - LENGTH(regexp_replace('1,2,3', ',', '')) + 1;
执行结果:
‘1,2,3’为需要分割的字符串
SELECT REGEXP_SUBSTR('1,2,3', '[^,]+', 1, rownum)
from dual
connect by rownum <=
LENGTH('1,2,3') - LENGTH(regexp_replace('1,2,3', ',', '')) + 1;
执行结果: