SELECT REGEXP_SUBSTR('A,B,C','[^,]+',1,LEVEL)
FROM DUAL
CONNECT BY LEVEL<=LENGTH('A,B,C')-LENGTH(REPLACE('A,B,C',','))+1
字符串为A,B,C
执行完
SELECT REGEXP_SUBSTR('A,B,C','[^,]+',1,LEVEL)
FROM DUAL
CONNECT BY LEVEL<=LENGTH('A,B,C')-LENGTH(REPLACE('A,B,C',','))+1
字符串为A,B,C
执行完