title: oracle sql where column in subquery with parameter
body: <p>I want to test whether the values in a parameter delimited by a comma is in the column.</p>
  
  <p>Value for :param_ is something like this:</p>
  
  <p><strong>Hi,Hello,World</strong></p>
  
  <p>I want my query to have a result like in this query:</p>
  
  <pre><code>SELECT col FROM tbl1 
  WHERE col IN ('Hi','Hello','World');
  </code></pre>
  
  <p>I tried:</p>
  
  <pre><code>SELECT col FROM tbl1 
  WHERE col IN (
  SELECT SUBSTR( SUBSTR('''' || REPLACE(:param_, ',', ''',''') || '''', 1, 
  LENGTH('''' || REPLACE(:param_, ',', ''',''') || '''') - 1), 2, 
  LENGTH( SUBSTR('''' || REPLACE(:param_, ',', ''',''') || '''', 1, LENGTH(''''
  || REPLACE(:param_, ',', ''',''') || '''') - 1) ) - 1 ) 
  FROM tbl1);
  </code></pre>
  
  <p>The subquery in the code that I tried has the output <strong>Hi','Hello','World</strong>. I removed the first and last single quote because I thought that it will have when it is inputted as a string and will be <strong>'Hi','Hello','World'</strong> in the IN clause</p>