title: Oracle Insert All vs Insert
body: <p>In Oracle I came across two types of insert statement </p>
  
  <p>1) Insert All: Multiple entries can be inserted using a single sql statement</p>
  
  <p>2) Insert : One entry will be updated per insert.</p>
  
  <p>Now I want to insert around 100,000 records at a time. (Table have 10 fields with includes a primary key). I am not concerned about any return value.</p>
  
  <p>I am using oracle 11g.</p>
  
  <p>Can you please help me with respect to <strong>performance</strong> which is better "Insert" or "Insert All".</p>