title: To fetch more than 1000 records using an IN clause
body: <p>I am using sql developer on an oracle database. My requirement is to pull out more than 8000 rows at once using primary key ID's that I have. sql developer doesn't allow me to fetch more than 1000 at once. All I can do is add an OR and pull a maximum of 2000(1000+1000). Is there a better way to pull ALL at once? </p>
  
  <p>If a temporary table needs to be used, how do i go about it in oracle?</p>
  
  <pre><code>Select * from X where ID in (1,2,...1000) OR ID IN (1001,1002,...2000);
  </code></pre>
  
  <p>Thank you</p>