title: Query performance difference pl/sql forall insert and plain SQL insert
body: <p>We have been using temporary table to store intermediate results in pl/sql Stored procedure. Could anyone tell if there is a performance difference between doing bulk collect insert through pl/sql and a plain SQL insert.</p>
  
  <p>Insert into [Table name] [Select query Returning huge amount of data]</p>
  
  <p>or</p>
  
  <p>Cursor for [Select query returning huge amount of data]</p>
  
  <p>open cursor</p>
  
  <p>fetch cursor bulk collect into collection</p>
  
  <p>Use FORALL to perform insert</p>
  
  <p>Which of the above 2 options is better to insert huge amount of temporary data?. </p>