title: how to pass a variable in WHERE IN clause of oracle sql?
body: <p>Hi<br>
  I have a variable $1 which hold comma separated email addresses like john@example.com,pat@example.com . I wish to pass this variable in a where clause like</p>
  
  <pre><code>where myColumn in ($1)
  </code></pre>
  
  <p>But obviously this won't work, I tried APEX_UTIL.STRING_TO_TABLE and DBMS_UTILITY.COMMA_TO_TABLE but in vain.</p>
  
  <p>Any help appreciated.</p>