title: Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
body: <p>Is there a workaround for </p>
  
  <p><code>'ORA-01795: maximum number of expressions in a list is 1000 error'</code></p>
  
  <p>I have a query and it is selecting fields based on the value of one field. I am using the in clause and there are 10000+ values </p>
  
  <p>example: </p>
  
  <pre><code>select field1, field2, field3 
  from table1 
  where name in 
  (
  'value1',
  'value2',
  ...
  'value10000+'
  );
  </code></pre>
  
  <p>Every time I execute the query I get the <code>ORA-01795: maximum number of expressions in a list is 1000 error</code>. I am trying to execute the query in TOAD, no difference, the same error. How would I modify the query to get it to work? </p>
  
  <p>Thanks in advance</p>