title: Alternatives to using SQL IN in this query
body: <p>I have a string holding comma separated values = value1, value2, value3 .......</p>
  
  <p>I want to perform following operation:</p>
  
  <pre><code>SELECT col FROM table WHERE col IN :values
  </code></pre>
  
  <p>This works fine if values have less than 1000 entries. It gives error when values have more than 1000 entries. There is a limit on usage of IN.</p>
  
  <p>Is there any alternative way to perform this query? </p>
  
  <p>EDIT: 
  It is Oracle's Business Intelligence Publisher application. Customer/User can use any database underneath.</p>
  
  <p>I do not have control over database. So I cannot create a temp table or stored procedure. All I can do is select multiple values from UI screen (it forms comma separated string) and use it in a SQL query. Depending on which reports are generated.</p>
  
  <ul>
  <li>Cannot use EXISTS with static string values.</li>
  <li>Cannot use stored procedure or temp table.</li>
  </ul>