title: Select all rows which occure in list of 2927 id's
body: <p>I have a list of 2927 id's. I want to get all rows which id's are in that list. How can I achieve this? It is a comma seperated list of id's. An in statement won't work since there is a limit of 1000. I've tried solutions like this <a href="https://stackoverflow.com/questions/10798161/loop-through-pre-defined-values">Loop through pre defined values</a> but it doesn't do what I expect.</p>
  
  <p>I'm using toad and I wish to see the rows in the datagrid (multiple rows, multiple columns).</p>
  
  <p>Thanks in advance!</p>
  
  <p>How a list of id's may look like:</p>
  
  <blockquote>
    <p>67,122,173,256,284,285,288,289,291,294,296,298,301,320,346,359,366,425,428,454,528,573,576,584,593,654,654,694,722,838,1833,1976,1979,1979,2002,2004,2005,2045,2083,2109,2114,2126,2126,2157,2204,2204,2211,2212,2332,2576,...</p>
  </blockquote>
  
  <p>How the statement would be when the limit of 1000 isn't reached:</p>
  
  <pre><code>Select * from tablename where tablename.id in (67,122,173,256,284,285,288,289,291,294,296,298,301,320,346,359,366,425,428,454,528,573,576,584,593,654,654,694,722,838,1833,1976,1979,1979,2002,2004,2005,2045,2083,2109,2114,2126,2126,2157,2204,2204,2211,2212,2332,2576);
  </code></pre>