Re: How do I retrieve free values?

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Fri, 23 Aug 2002 09:09:04 -0600
Message-ID: <3D665010.741EC6B3@noaa.gov>

Okey-dokey. This will work well, but only if the number of rows in the all_objects table is sufficiently large...

Lars Reineke wrote:

> > Using a table with at least as many rows as the max integer you can use
> the
> > MINUS operator.
>
> This is exactly what I was looking for. Thank you very much!
>
> This is the query I am using now, and it works absolutely perfect:
>
> select rownum from all_objects where rownum < (select max(nr) from theTable)
> minus
> select nr from theTable
Received on Fri Aug 23 2002 - 10:09:04 CDT