title: Oracle SQL: How to use more than 1000 items inside an IN clause
body: <p>I have an SQL statement where I would like to get data of 1200 <code>ep_codes</code> by making use of <code>IN</code> clause. When I include more than 1000 <code>ep_codes</code> inside IN clause, Oracle says I'm not allowed to do that. To overcome this, I tried to change the SQL code as follows:</p>
  
  <pre><code>SELECT period, ...
  FROM   my_view
  WHERE  period = '200912'
         ...
         AND ep_codes IN (...1000 ep_codes...)
         OR  ep_codes IN (...200 ep_codes...)
  </code></pre>
  
  <p>The code was executed succesfully but the results are strange (calculation results are fetched for all periods, not just for 200912, which is not what I want). Is it appropriate to do that using <code>OR</code> between <code>IN</code> clauses or should I execute two separate codes as one with 1000 and the other with 200 ep_codes?</p>
  
  <hr>
  
  <p>Pascal Martin's solution worked perfectly. Thanks all who contributed with valuable suggestions.</p>