ip转换函数 给你一个建议,每个点之间都补全3位,取出来的时候,用to_number就可以了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select lpad(substr('192.168.1.2',1,instr('192.168.1.2','.',1,1) -1),3,'0') as ip1,lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,1) + 1,instr('192.168.1.2','.',1,2) -instr('192.168.1.2','.',1,1) -1),3,'0') as ip2,lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,2) + 1,instr('192.168.1.2','.',1,3) -instr('192.168.1.2','.',1,2) -1),3,'0') as ip3,lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,3) + 1,length('192.168.1.2') - instr('192.168.1.2','.',1,3)),3,'0') as ip4from dual IP换成数字的select to_number(lpad(substr('192.168.1.2',1,instr('192.168.1.2','.',1,1) -1),3,'0') ||lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,1) + 1,instr('192.168.1.2','.',1,2) -instr('192.168.1.2','.',1,1) -1),3,'0') ||lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,2) + 1,instr('192.168.1.2','.',1,3) -instr('192.168.1.2','.',1,2) -1),3,'0') ||lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,3) + 1,length('192.168.1.2') - instr('192.168.1.2','.',1,3)),3,'0')) as ipfrom dual数字换成ip的select substr(192168001002,1,length(192168001002) -9) || '.' ||to_number(substr(192168001002,12 -length(192168001002) + 4,3)) || '.' ||to_number(substr(192168001002,12 -length(192168001002) + 7,3)) || '.' ||to_number(substr(192168001002,12 -length(192168001002) + 10,3)) as ipfrom dual 存储过程中的错误 Oracle中如何把存进去的二进制文件转换成图片文件 问大家一个rman的问题,急,在线等 如何创建触发器 关于游标使用的一个疑问? 新年高分献上,不够在加,只要大家快乐!!! 问个sql的写法 powerdisigner中数据库模型UML把它在找开怎么不显示?为什么? 一个关于Oracle的ODBC问题 创建数据库出错:invalid entry size 刚学oracle开发,出现问题大家帮忙顶顶啊,别让我失去信心啊******(^@^,^@^)******* 急问!!!!!来者有分!!!!!
lpad(substr('192.168.1.2',1,instr('192.168.1.2','.',1,1) -1),3,'0') as ip1,
lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,1) + 1,instr('192.168.1.2','.',1,2) -instr('192.168.1.2','.',1,1) -1),3,'0') as ip2,
lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,2) + 1,instr('192.168.1.2','.',1,3) -instr('192.168.1.2','.',1,2) -1),3,'0') as ip3,
lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,3) + 1,length('192.168.1.2') - instr('192.168.1.2','.',1,3)),3,'0') as ip4
from dual
select to_number(
lpad(substr('192.168.1.2',1,instr('192.168.1.2','.',1,1) -1),3,'0') ||
lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,1) + 1,instr('192.168.1.2','.',1,2) -instr('192.168.1.2','.',1,1) -1),3,'0') ||
lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,2) + 1,instr('192.168.1.2','.',1,3) -instr('192.168.1.2','.',1,2) -1),3,'0') ||
lpad(substr('192.168.1.2',instr('192.168.1.2','.',1,3) + 1,length('192.168.1.2') - instr('192.168.1.2','.',1,3)),3,'0')) as ip
from dual数字换成ip的
select
substr(192168001002,1,length(192168001002) -9) || '.' ||
to_number(substr(192168001002,12 -length(192168001002) + 4,3)) || '.' ||
to_number(substr(192168001002,12 -length(192168001002) + 7,3)) || '.' ||
to_number(substr(192168001002,12 -length(192168001002) + 10,3)) as ip
from dual