Oracle进行select时如何split SELECT REGEXP_SUBSTR('1,2,3,4,5,6,7','[^,]+',1,LEVEL,'i') FROM DUAL CONNECT BY LEVEL <= LENGTH('1,2,3,4,5,6,7')- LENGTH(REGEXP_REPLACE('1,2,3,4,5,6,7',',',''))+1