[123688] in North American Network Operators' Group
Re: PL/SQL & CIDR?
daemon@ATHENA.MIT.EDU (Seth Mattinen)
Fri Mar 12 21:07:32 2010
Date: Fri, 12 Mar 2010 18:06:59 -0800
From: Seth Mattinen <sethm@rollernet.us>
To: nanog@nanog.org
In-Reply-To: <3DDC8C81-5D30-4C54-8E8E-283003E1A539@cybernothing.org>
Errors-To: nanog-bounces+nanog.discuss=bloom-picayune.mit.edu@nanog.org
On 3/12/2010 09:13, J.D. Falk wrote:
> Does anyone know of a library, sample code, etc. to help Oracle PL/SQL do CIDR math?
>
Not exactly sample code, but: I do that with MySQL by storing the IP as
its integer value and using simple comparisons to see if that stored
value is within the range of values that a given CIDR mask represents.
Works great for IPv4 and IPv6 addresses.
~Seth
