title: Is there a way to do an INSERT INTO SELECT statement while specifying a commit count?
body: <p>DB: Oracle 11g</p>
  
  <p>Is there a way to do something like the following:</p>
  
  <pre><code>INSERT INTO T1
      (V1, V2)
  COMMIT EVERY X
  AS
  SELECT (V1, V2) FROM T2;
  </code></pre>
  
  <p>I know how to loop through cursor, but I'm looking for something more streamlined.</p>
  
  <p>PL/SQL is fine, but no looping.<br>
  Using a SQL Hint is good too.</p>
  
  <p>If this is just something that oracle can't handle, sadness ensues (Mostly I'm just curious since I have another approach working already).</p>
  
  <p>NOTE: The application has hundreds of billions of records. Millions are created per day. INSERT INTO SELECT doesn't work on such large sets of data. Especially when there are equally large sets running in parallel.</p>