 | |
IP address from long
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
IP address from long -
05-27-2008
, 11:09 AM
#2
| |||
| |||
|
|
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 |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#3
| |||
| |||
|
|
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 |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#4
| |||
| |||
|
|
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 |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#5
| |||
| |||
|
|
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 |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#6
| |||
| |||
|
|
Á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. but you can always include your function in java or similar if you want. |
as stored procedure. I think its called orapig or something like that.
d.
#7
| |||
| |||
|
|
Á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. but you can always include your function in java or similar if you want. |
as stored procedure. I think its called orapig or something like that.
d.
#8
| |||
| |||
|
|
Á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. but you can always include your function in java or similar if you want. |
as stored procedure. I think its called orapig or something like that.
d.
#9
| |||
| |||
|
|
Á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. but you can always include your function in java or similar if you want. |
as stored procedure. I think its called orapig or something like that.
d.
#10
| |||
| |||
|
|
Á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
|
« 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.