Newbie: Get a list of values that are NOT in a table column
Hi,
Given a list of values, I can get which are in a table column:
SQL> desc a
Nombre +Nulo? Tipo
----------------------------------------- -------- ----------------------------
COL1 NUMBER(38)
SQL> select * from a;
COL1
----------
1
2
3
4
5
SQL> select * from a where col1 in (1,3,4, 7, 9, 11);
COL1
----------
1
3
4
How can I get the values that are not in the table column?
Thanks in advance,
Jose Luis