select id
from tbl
where id not in (коллекция)

create type gtype_vc30 as table of varchar2( 30 );
declare
  a_coll  gtype_vc30 := gtype_vc30();
begin
  a_coll.extend( 3 );
  a_coll( 1 ) := 'SYS';
  a_coll( 2 ) := 'SYSTEM';
  a_coll( 3 ) := 'SCOTT';
  for c1 in (
    select a.*
      from all_users a
     where username not in 
      (select column_value
         from table(cast(a_coll as gtype_vc30)))
     order by  1 
  ) loop
    dbms_output.put_line(c1.username);
  end loop;
end;