title: how to add more than 1000 values with NOT IN clause
body: <p>I have comma delimited id's that I want to use in NOT IN clause.. 
  I'm using oracle 11g. </p>
  
  <pre><code>select * from table where ID NOT IN (1,2,3,4,...,1001,1002,...)
  </code></pre>
  
  <p>results in</p>
  
  <pre><code>ORA-01795: maximum number of expressions in a list is 1000
  </code></pre>
  
  <p>I don't want to use temp table. am trying considering doing this</p>
  
  <pre><code>select * from table1 where ID NOT IN (1,2,3,4,…,1000) AND 
  ID NOT IN (1001,1002,…,2000)
  </code></pre>
  
  <p>Is there any other better workaround to this issue?</p>