ORA-01795 maximum number of expressions in a list is 1000
<p>I am getting the error</p>

<blockquote>
  <p>ORA-01795 maximum number of expressions in a list is 1000</p>
</blockquote>

<p>for the below query</p>

<pre><code>select emp_id, emp_name, emp_code
from emp e
where emp_id in (001,002,005,006....18000);
</code></pre>

<p>I need to put 18000 records in the <code>IN</code> clause. How can I achieve this? How can I modify my given query?</p>