title: Inserting multiple rows into Oracle
body: <p>In the <a href="https://stackoverflow.com/questions/39576/best-way-to-do-multi-row-insert-in-oracle#39602">discussion</a> about multiple row insert into the Oracle two approaches were demonstrated:</p>
  
  <p>First: </p>
  
  <pre><code>insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE)
            select 8000,0,'Multi 8000',1 from dual
  union all select 8001,0,'Multi 8001',1 from dual
  </code></pre>
  
  <p>Second:</p>
  
  <pre><code>INSERT ALL
     INTO t (col1, col2, col3) VALUES ('val1_1', 'val1_2', 'val1_3')
     INTO t (col1, col2, col3) VALUES ('val2_1', 'val2_2', 'val2_3')
     INTO t (col1, col2, col3) VALUES ('val3_1', 'val3_2', 'val3_3')
     .
     .
     .
  SELECT 1 FROM DUAL;
  </code></pre>
  
  <p>Could anyone argue the preference of using one over another?</p>
  
  <p>P.S. I didn't do any research myself (even explanation plan), so any information or opinion would be appreciated.</p>
  
  <p>Thanks.</p>