Link to home
Start Free TrialLog in
Avatar of straniero
straniero

asked on

a simple question

hallo, i'm relatively new to oracle and i know this will be a simple question for most of you, hope somebody can help:
i have a colum that stores numbers (no duplicate data are allowed) and i need to know which numbers are not in the column. how may i do that?
thanks in advance
Avatar of grim_toaster
grim_toaster

I'm presuming you have some sort of boundary values as if you had a table with only 2 values, would you want everything up to and beyond infinity???
Avatar of straniero

ASKER

yes sorry i forgot it, there are boundaries: values must range between 1 and the highest value in the column. simply, i developed an app to administer helpdesk calls and everytime i add a call a new line is added with a number that is the highest number in the column + 1. due to a problem in early versions of the software, to avoid duplicates some numbers are not used and now i need to know which are those numbers.
ASKER CERTIFIED SOLUTION
Avatar of Ora_Techie
Ora_Techie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks a lot
you have more than helped me