Declare
Val varchar2 (1024);
Val_new VARCHAR2 (1024);
I integer;
P1 integer;
P2 integer;
P3 integer;
P4 integer;
IP integer;
Begin
Val: = ' 192.168.010.017 ';
P1: = 0;
P2: = 0;
P3: = 0;
P4: = 0;
I: = InStr (Val, '. ', 1);
If I <> 0 Then
Val_new: = substr (val,1,i-1);
P1: = To_number (val_new);
Dbms_output.put_line (To_char (p1));
Val: = substr (val,i+1);
I: = InStr (Val, '. ', 1);
If I <> 0 Then
Val_new: = substr (val,1,i-1);
P2: = To_number (val_new);
Dbms_output.put_line (To_char (p2));
Val: = substr (val,i+1);
I: = InStr (Val, '. ', 1);
If I <> 0 Then
Val_new: = substr (val,1,i-1);
P3: = To_number (val_new);
Dbms_output.put_line (To_char (p3));
Val: = substr (val,i+1);
P4: = To_number (val);
Dbms_output.put_line (To_char (p4));
End If;
End If;
End If;
IP: = P4 + p3* (Power (2,8)) + p2* (Power (2,16)) + p1* (Power (2,24));
Dbms_output.put_line (To_char (IP));
exception
When others then
Null
End
IP address word representable int (version plsql)