select substr(replace('1,2,3,4',',',''),rownum,1)
from dual connect by rownum <= length(replace('1,2,3,4',',',''));
输出结果如下:
SUBS
-----------------------
1
2
3
4
select substr(replace('1,2,3,4',',',''),rownum,1)
from dual connect by rownum <= length(replace('1,2,3,4',',',''));
输出结果如下: