12 Mar
2010
12 Mar
'10
9:36 p.m.
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