level 配合substr 和instr 进行字符串截取

假设字符串是比较规则的

0123456789

截取成 
0
1
2
3
4
5
6
7
8
9




select substr('0123456789',level,1)qq from dual connect by level<= length('0123456789');




'01,23,45,67,89' 


截取成
01
23
45
67
89


select substr('01,23,45,67,89',instr('01,23,45,67,89',',',1,level)-2,2)qq from 
dual connect by level<= regexp_count('01,23,45,67,89',',')+1 ;