title: Oracle IN clause limitation
body: <p>As we all know, the IN clause in Oracle is limited to 1000 elements.</p>
  
  <p>One point I am not sure is, can I go beyond 1000 if they are the result of a query.</p>
  
  <p>For instance, if we assume that :</p>
  
  <pre><code>SELECT TYPEID FROM SECONDTABLE WHERE DATE &lt; YESTERDAY
  </code></pre>
  
  <p>assuming that query returns 4300 values, can we write:</p>
  
  <pre><code>SELECT
    ID
  FROM
    FIRSTTABLE
  WHERE
    TYPEID IN (SELECT TYPEID FROM SECONDTABLE WHERE DATE &lt; YESTERDAY)
  </code></pre>
  
  <p>? Since the IN contains ONE statement to begin with (but 4300 once "expanded").</p>