Unsigned integer to IP address?
From: Monica Roman <monicaroman_at_yahoo.com>
Date: 2 Oct 2003 11:11:38 -0700
Message-ID: <9eb77af5.0310021011.33ab8a4e_at_posting.google.com>
Date: 2 Oct 2003 11:11:38 -0700
Message-ID: <9eb77af5.0310021011.33ab8a4e_at_posting.google.com>
Hello everyone,
My question is how to upload an unsigned integer so that it looks like
an IP address in Oracle?
A Perl program captures IP addresses from a log server and puts them
into a .csv file that I then sqload into Oracle. When I query the db
the numbers look very different e.g., (just an example) 2423598587
instead of 134.290.34.59 (this was made up, any similarity to real IP
is pure coincidence).
I need them to look like an IP address.
Monica Received on Thu Oct 02 2003 - 20:11:38 CEST