title: select from employee table where index is not in a collection
body: <p>I have a procedure like below:</p>
  
  <pre><code>SET serveroutput ON 
      DECLARE 
          TYPE list_of_names_t 
            IS TABLE OF emp.emp_index%TYPE; 
          ignoreIndexes LIST_OF_NAMES_T := List_of_names_t();
      BEGIN
      -- Logic here which fills the values in the collection ignoreIndexes and           considerIndexes  
      -- Line XX   
  END;
  </code></pre>
  
  <p>At Line XX, I want to add the below line</p>
  
  <p><code>SELECT * FROM emp WHERE emp_index NOT IN ignoreIndexes</code> But not able to get the correct syntax, How to make that possible?</p>