从给定集合中查找表中缺少的值

您需要从一个包含正在检查的值的(派生)表开始。一种明确的方法是:

with testvalues as (
      select 'G' as val from dual union all
      select 'H' as val from dual union all
      select 'I' as val from dual union all
      select 'J' as val from dual 
     )
select tv.val
from testvalues tv
where not exists (select 1 from allvalues av where av.column = tv.val);

取决于您可以使用哪种SQL语法,但基本上您希望检查表allvalues+额外的值。

如:

SELECT *                                 
FROM ALLVALUES                           
WHERE COLUMN NOT IN (                    
( select s.column from allvalues s )     
and column not in ('G', 'H', 'I', 'J') 

    select * from table1;
    G
    H
    I
    J

    select * from table1
    minus
    (select * from table1
    intersect 
    select column from allvalues
    )
sample input:

select * from  ns_table10;
G
H
I
J
SELECT * FROM ns_table11;
A
B
C
D
E
F
G
J
I
select * from ns_table10
minus
(select * from ns_table10
intersect 
select * from ns_table11
);

output:
H