oracle转成整型_ip字符串与整型相互转换的函数

ip字符串与整型相互转换都是用编程语言实现的,下面我试着在数据库中实现这样的功能.

1.字符串ip转换成整型表示

CREATE OR REPLACE Function Ip_Str2long(Strip In String) Return Integer As

Ip1 Varchar2(10);

Ip2 Varchar2(10);

Ip3 Varchar2(10);

Ip4 Varchar2(10);

Temp Varchar2(20);

Result Integer;

Begin

Temp := Strip;

Ip1 := Substr(Temp, 1, Instr(Temp, '.', 1, 1) - 1);

Ip2 := Substr(Temp,

Instr(Temp, '.', 1, 1) + 1,

Instr(Temp, '.', 1, 2) - Length(Ip1) - 2);

Ip3 := Substr(Temp,

Instr(Temp, '.', 1, 2) + 1,

Instr(Temp, '.', 1, 3) - Length(Ip1) - Length(Ip2) - 3);

Ip4 := Substr(Temp,

Instr(Temp, '.', 1, 3) + 1,

Length(Temp) - Length(Ip1) - Length(Ip2) - 4);

Result := To_Number(Ip1) * 16777216 + To_Number(Ip2) * 65536 +

To_Number(