Re: PL/SQL & CIDR?

[Matthew Kaufman <matthew () matthew at>]

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