Re: How do I retrieve free values?

> 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 - 05:59:04 CDT