with q (id) as (values 'id1', 'id2', ...)
select id
from q
where id not in (select id from table1)
 

with q as (select column_value id from table(sys.odcivarchar2list('id1', 'id2', 'id3')))
select * from q where q.id not in (select id from table1)

with q (id) as (values 'id1', 'id2', ...)
select id
from q
where id not in (select id from table1)
 

with q(id) as (
select 1 from dual union all
select 2 from dual union all
select 45 from dual union all
select 3 from dual
)
select id
from q
where id not in (select id from table1)
;

with q as (select column_value id from table(sys.odcivarchar2list('id1', 'id2', 'id3')))
select * from q where not exists(select 1 from table1 t where t.id = q.id)