title: Oracle - In CLAUSE question when using with multiple values, making it dynamic
body: <p>I just spent an hour on google and here trying to get a straight answer for how to do this in Oracle. What I need is the ability to use select in clause that constructed automatically such as </p>
  
  <pre><code>select col1 from table1 where id.table IN ('1','2','3');
  </code></pre>
  
  <p>where the id values are passed to the stored procedure inside the array. The associative array has been defined as such:</p>
  
  <pre><code> TYPE varchar_array_type IS TABLE OF VARCHAR2 (40)      INDEX BY BINARY_INTEGER;
  </code></pre>
  
  <p>Is there a simple, concrete way to do that? thanks</p>