PL/SQL & CIDR?

Matthew Kaufman matthew at matthew.at
Fri Mar 12 20:36:08 CST 2010


Seth Mattinen wrote:
> 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
>
>   
I do it in MySQL by storing the IP as an integer and the mask as an 
integer and using bitwise operators in the SELECT.

Just something to think about...

Matthew Kaufman




More information about the NANOG mailing list