oracle - Determine which values are not in sql table -
oracle - Determine which values are not in sql table - i have query in oracle: select * table col2 in (1,2,3,4); lets got result col1 | col2 ----------- 1 b 2 my 'in (1,2,3,4)' part has 20 or more options, how can determinate values don't found in table? in illustration 3 , 4 doesn't exist in table you can't in way want. you need insert values want find table , select values don't exist in desired table. lets info want find in a , want know doesn't exist in b . select * table_a not exists (select * table_b b b.col1 = a.col1); sql oracle