nanog mailing list archives

Re: PL/SQL & CIDR?


From: Seth Mattinen <sethm () rollernet us>
Date: Fri, 12 Mar 2010 18:06:59 -0800

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


Current thread: