[PL/SQL] signed int -> IP
From: Yao ChunLi <yaoc_at_shell.unixbox.com>
Date: 1997/11/21
Message-ID: <Pine.LNX.3.96.971121140335.5142A-100000_at_shell.unixbox.com>#1/1
Date: 1997/11/21
Message-ID: <Pine.LNX.3.96.971121140335.5142A-100000_at_shell.unixbox.com>#1/1
Is there a way to convert IP address with signed integer format to dot notation by using stored procedure? Something like inet_ntoa in C.
For example, we have an IP address(-2062683858) saved in Oracle with the datatype number(the data was inserted from a Java application). How can you convert -2062683858 to 133.13.241.46?
Thanks for any input!
Chunli Yao Received on Fri Nov 21 1997 - 00:00:00 CET