sql - Which value(s) in WHERE CLAUSE LIST are not available in the table -

sql - Which value(s) in WHERE CLAUSE LIST are not available in the table -

i want search value(s) in clause list not available in table.

table name test

column1 -------------- 1 2 3

my query : have search list 2, 3, 4, 5 , want see not in database. when query, should 4, 5 , not 1.

i not want list of values there in table , not in clause list(select * test column1 not in (2, 3, 4, 5)

can please help ?

my_list (select regexp_substr('2,3,4,5', '[^,]+', 1, level) search_val dual connect level <= regexp_count('2,3,4,5',',') + 1 ) select * my_list not exists (select 'x' your_table your_column = search_val );

let's convert comma separated values view , what's needed.

sql oracle