title: Bulk Collect Twice over same nested table
body: <p>Is there any way that after the second bulk collect, data does not get override of the first bulk collect. I don't want to iterate in loop.</p>
  
  <pre><code>    DECLARE
         TYPE abc IS RECORD (p_id part.p_id%TYPE);
  
         TYPE abc_nt
         IS
            TABLE OF abc
               INDEX BY BINARY_INTEGER;
  
         v_abc_nt      abc_nt;
      BEGIN
         SELECT   p_id
           BULK   COLLECT
           INTO   v_abc_nt
           FROM   part
          WHERE   p_id IN ('E1', 'E2');
  
         SELECT   p_id
           BULK   COLLECT
           INTO   v_abc_nt
           FROM   part
          WHERE   p_id IN ('E3', 'E4');
  
         FOR i IN v_abc_nt.FIRST .. v_abc_nt.LAST
         LOOP
            DBMS_OUTPUT.put_line (
               'p_id is ' || v_abc_nt (i).p_id
            );
         END LOOP;
      END;
  </code></pre>
  
  <p><strong>OUTPUT:</strong></p>
  
  <ul>
  <li>p_id is E3</li>
  <li>p_id is E4</li>
  </ul>
  
  <p><em>Note: E1 and E2 is present in part table.</em></p>