title: Bulk Insert into Oracle database: Which is better: FOR Cursor loop or a simple Select?
body: <p>Which would be a better option for bulk insert into an Oracle database ? 
  A FOR Cursor loop like</p>
  
  <pre><code>DECLARE
     CURSOR C1 IS SELECT * FROM FOO;
  BEGIN
     FOR C1_REC IN C1 LOOP
     INSERT INTO BAR(A,
                  B,
                  C)
            VALUES(C1.A,
                   C1.B,
                   C1.C);
     END LOOP;
  END
  </code></pre>
  
  <p>or a simple select, like:</p>
  
  <pre><code>INSERT INTO BAR(A,
                  B,
                  C)
          (SELECT A,
                  B,
                  C
          FROM FOO);
  </code></pre>
  
  <p>Any specific reason either one would be better ?</p>