Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select between range, not in...

Re: Select between range, not in...

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Fri, 12 Dec 2003 11:59:59 -0600
Message-ID: <ef0ktv0g0jmnn5he0ft8fdq4p8eqr37rn2@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US