 | |
IP address from long
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: IP address from long -
05-27-2008
, 01:24 PM
|
Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. |
SQL> with t as (
2 select 3494755494 ip from dual
3 )
4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' ||
5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' ||
6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' ||
7 bitand(ip, power(2, 8) - 1) ip_dot
8 from t
9 /
IP_DOT
--------------
208.77.188.166
Best regards
Maxim
#12
| |||
| |||
|
|
Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. |
SQL> with t as (
2 select 3494755494 ip from dual
3 )
4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' ||
5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' ||
6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' ||
7 bitand(ip, power(2, 8) - 1) ip_dot
8 from t
9 /
IP_DOT
--------------
208.77.188.166
Best regards
Maxim
#13
| |||
| |||
|
|
Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. |
SQL> with t as (
2 select 3494755494 ip from dual
3 )
4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' ||
5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' ||
6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' ||
7 bitand(ip, power(2, 8) - 1) ip_dot
8 from t
9 /
IP_DOT
--------------
208.77.188.166
Best regards
Maxim
#14
| |||
| |||
|
|
DA Morgan schrieb: Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. On the other side, it is a matter of few keystrokes to do it yourself... SQL> with t as ( 2 select 3494755494 ip from dual 3 ) 4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' || 5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' || 6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' || 7 bitand(ip, power(2, 8) - 1) ip_dot 8 from t 9 / IP_DOT -------------- 208.77.188.166 Best regards Maxim even better  |
#15
| |||
| |||
|
|
DA Morgan schrieb: Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. On the other side, it is a matter of few keystrokes to do it yourself... SQL> with t as ( 2 select 3494755494 ip from dual 3 ) 4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' || 5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' || 6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' || 7 bitand(ip, power(2, 8) - 1) ip_dot 8 from t 9 / IP_DOT -------------- 208.77.188.166 Best regards Maxim even better |
#16
| |||
| |||
|
|
DA Morgan schrieb: Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. On the other side, it is a matter of few keystrokes to do it yourself... SQL> with t as ( 2 select 3494755494 ip from dual 3 ) 4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' || 5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' || 6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' || 7 bitand(ip, power(2, 8) - 1) ip_dot 8 from t 9 / IP_DOT -------------- 208.77.188.166 Best regards Maxim even better |
#17
| |||
| |||
|
|
DA Morgan schrieb: Álvaro G. Vicario wrote: Does Oracle (10g) have a built-in function to convert an IPv4 address in long format into dot notation? For example from 3494755494 to 208.77.188.166 No. On the other side, it is a matter of few keystrokes to do it yourself... SQL> with t as ( 2 select 3494755494 ip from dual 3 ) 4 select bitand(ip / power(2, 24), power(2, 8) - 1) || '.' || 5 bitand(ip / power(2, 16), power(2, 8) - 1) || '.' || 6 bitand(ip / power(2, 8), power(2, 8) - 1) || '.' || 7 bitand(ip, power(2, 8) - 1) ip_dot 8 from t 9 / IP_DOT -------------- 208.77.188.166 Best regards Maxim even better |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.