Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select between range, not in...
pretorianboy_at_yahoo.com (Pret Orian) wrote:
>Hi there!
>I have a table with used IP Adresses, and I have a table with
>subnetworks (with IP range: start/end).
>I need to make a select statement which would return the first free IP
>in range.
>The catch is I'd need to find a solution that would use basic SQL
>query as I have no permission to write SPs or functions.
>
>So this would be the table structures:
>
>Subnet:
>sune_id, ipstart, ipend, ...
>
>IPs:
>..., sune_id, ipadress
>
>note, ipstart, ipend and ipadress are plain integers (i.e. 4-Byte
>adresses downcalculated to integers, so you can refer to them
>acordingly).
>
>TIA
>PB
What determines if an address is free...
Received on Fri Dec 12 2003 - 11:59:59 CST