前端之家收集整理的这篇文章主要介绍了
oracle 分割,号，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
select "ID","START_IP","END_IP" from (with temp0 as (select LEVEL lv from dual CONNECT BY LEVEL <= 100)
@H_
403_0@ select ID,substr(t.vals,instr(t.vals,',1,tv.lv) + 1,@H_
403_0@ instr(t.vals,tv.lv + 1) -(
@H_
403_0@ instr(t.vals,tv.lv) + 1)
@H_
403_0@ ) AS start_ip,@H_
403_0@ substr(t.vals1,instr(t.vals1,@H_
403_0@ instr(t.vals1,tv.lv + 1) -(
@H_
403_0@ instr(t.vals1,tv.lv) + 1)
@H_
403_0@ ) AS end_ip
@H_
403_0@ from (select ID,' || start_ip || ',' AS vals,@H_
403_0@ length(start_ip || ',') - nvl(length(REPLACE(start_ip,')),0) AS cnt,@H_
403_0@ ',' || end_ip || ',' AS vals1,@H_
403_0@ length(end_ip || ',') - nvl(length(REPLACE(end_ip,0) AS cnt1
@H_
403_0@
@H_
403_0@ from HOST_WEBSITE_INFO) t join temp0 tv
@H_
403_0@
on tv.lv <= t.cnt order by 1)
@H_403_0@
注：功能分割start_ip，end_ip
