title: Oracle collection in where clause
body: <p>I am using collection in a oracle code block because there is no table variable(like in MS SQL Server). </p>
  
  <pre><code>DECLARE
      TYPE I_NAME IS TABLE OF NVARCHAR2(512);     
      I_ITEMNAME      I_NAME := I_NAME(); 
  BEGIN 
  </code></pre>
  
  <p>I am using "BULK COLLECT INTO I_ITEMNAME" to fill collection. <br/>
  I want to use this collection in WHERE clause in a SELECT query but not able to find method to do it. Currently i and using FOR loop and getting item one by one.<br/>
  How can i use collection directly in WHERE clause somethin like </p>
  
  <blockquote>
    <p>SELECT * FROM TBL WHERE COL IN I_ITEMNAME?</p>
  </blockquote>
  
  <p>Thank you,</p>