Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!80g2000cwy.googlegroups.com!not-for-mail
From: "maxwell.dana@gmail.com" <maxwell.dana@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: modelling IPv6 as a number
Date: 12 Dec 2006 11:35:18 -0800
Organization: http://groups.google.com
Lines: 10
Message-ID: <1165952118.737337.35940@80g2000cwy.googlegroups.com>
NNTP-Posting-Host: 142.128.64.198
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1165952125 15795 127.0.0.1 (12 Dec 2006 19:35:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 19:35:25 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 80g2000cwy.googlegroups.com; posting-host=142.128.64.198;
   posting-account=7RB87g0AAACUF5SXAGrPnkDYyhG3GLxY
Xref: usenetserver.com comp.databases.oracle.server:419039
X-Received-Date: Tue, 12 Dec 2006 14:35:25 EST (text.usenetserver.com)

Hi All,

If I'm not mistaken, IPv6 requires 39 significant digits to represent
each possible IP as an integer. Oracle's maximum is  number(38). Has
anyone devised a scheme to store the integer value of IPv6 in oracle?

Thanks

Dana