select REGEXP_SUBSTR(str, '[^,]+', 1, LEVEL) STR
from (select '1,2,3,4,5,6,7,8,9' str from dual)
CONNECT BY LEVEL <= REGEXP_COUNT(str, ',') + 1
from (select '1,2,3,4,5,6,7,8,9' str from dual)
CONNECT BY LEVEL <= REGEXP_COUNT(str, ',') + 1
调试欢乐多
from (select '1,2,3,4,5,6,7,8,9' str from dual)
CONNECT BY LEVEL <= length(REGEXP_REPLACE(str, '[^,]', '')) + 1