oracle REGEXP_SUBSTR函数

SELECT REGEXP_SUBSTR('first field, second field , third field',
'[^,]+',
1,
ROWNUM)
FROM DUAL
CONNECT BY ROWNUM <= LENGTH('first field, second field , third field') -
LENGTH(REPLACE('first field, second field , third field',
',',
'')) + 1;