求帮忙分离下字符串

[楚江南]

把字符串

‘50000000~77109999,77690000~78059999,78220000~78299999,78350000~78359999,78410000~78459999,78470000~78499999,78980000~99999999’

里面的数字截取出来，

跪求大神指教！！！！

[我心飞翔]

截取成什么格式的呢？

[forgetsam]

一条就
select regexp_substr('字符串','\w+',1,level) a from dual connect by level <=14

[yixilan]

接楼上，或者：
select regexp_substr('字符串','\d+',1,level) a from dual connect by level <=14

[xpingping]

select  regexp_substr('50000000~77109999,77690000~78059999,78220000~78299999,78350000~78359999,78410000~78459999,78470000~78499999,78980000~99999999
', '[^,]+', 1, rownum) from dual
connect by rownum <= length(regexp_replace('50000000~77109999,77690000~78059999,78220000~78299999,78350000~78359999,78410000~78459999,78470000~78499999,78980000~99999999
', '[^,]'))+1;