How do I retrieve free values?

From: Lars Reineke <reineke_at_kreiskrankenhaus-hameln.de>
Date: Thu, 22 Aug 2002 10:18:01 +0200
Message-ID: <ak26or$1ev86v$1@ID-1759.news.dfncis.de>

Hi!

Given a table A with a column NUMBER, which stores numerical values, let's say in a range from 1 to 9999, how do I retrieve the values that are in that range but not stored into that table?

NUMBER

---

1
2
3
4
5
7
8
10

I would like to get the not assigned 6, the 9 and so on.

Many thanks in advance.

Greetings
Lars Received on Thu Aug 22 2002 - 03:18:01 CDT