Oracle通过正则表达式分割字符串 REGEXP_SUBSTR的代码详解

function REGEXP_SUBSTR(string, pattern, position, occurrence, modifier) 

SELECT REGEXP_SUBSTR('123,,,ABC,!@#,,,', '[^,]+') FROM DUAL ;

SELECT REGEXP_SUBSTR('123,,,ABC,!@#,,,', '[^,]+', 2) FROM DUAL ;

SELECT REGEXP_SUBSTR('123,,,ABC,!@#,,,', '[^,]+', 1, 2) FROM DUAL ;

SELECT REGEXP_SUBSTR('123,,,ABaC,!@#,,,', '[^a]+', 1, 2, 'i') FROM DUAL ;

SELECT REGEXP_SUBSTR('123,,,ABaC,!@#,,,', '[^a]+', 1, 2, 'c') FROM DUAL ;

SELECT REGEXP_SUBSTR('123,,,ABC,!@#,,,', '[^,]+', 1, LEVEL) 
FROM DUAL 
CONNECT BY REGEXP_SUBSTR('123,,,ABC,!@#,,,', '[^,]+', 1, LEVEL) IS NOT NULL;