title: Oracle PL/SQL - How do i copy a large amount of data from one table to another using oracle collections
body: <p>This is part of an assignment to test the processing speed of each oracle collection (associative array, variable array, and nested tables), but i'm unsure how to approach this - i'm fairly new to PL/SQL and oracle in general.</p>
  
  <p>So i have two tables created - one contains three columns, with over 3 million records, the other is empty. How do i copy the data from the filled table to the empty one using the collection method? </p>
  
  <p>Thanks in advance - please excuse me if i did not provide enough information - i'm fairly new to this...</p>
  
  <p>Richard</p>