示例1:拆分个数固定
select regexp_substr ('1,2,3', '[^,]+', 1, rownum) num
from dual
connect by rownum<=length('1,2,3') - length(regexp_replace('1,2,3', ',', '')) + 1
示例2:拆分个数不固定
select regexp_substr('1,2,3','[^,]+',1,lv) num
from dual, (select level lv from dual connect by level <= 10)
where lv <= length('1,2,3') - length(replace('1,2,3',',')) + 1