PL/SQL & CIDR?
Matthew Kaufman
matthew at matthew.at
Sat Mar 13 02:36:08 UTC 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