title: Oracle 'INSERT ALL' ignore duplicates
body: <p>I have a database table with a unique constraint on it (unique <code>(DADSNBR, DAROLEID)</code> pair). I am going to be inserting multiple values into this table simultaneously, so I'd like to get it done using one query - I'm assuming this would be the faster way. My query is thus:</p>
  
  <pre><code>INSERT ALL
      INTO ACCESS (DADSNBR, DAROLEID) VALUES (68, 1)
      INTO ACCESS (DADSNBR, DAROLEID) VALUES (68, 2)
      INTO ACCESS (DADSNBR, DAROLEID) VALUES (68, 3)
      INTO ACCESS (DADSNBR, DAROLEID) VALUES (68, 4)
  SELECT 1 FROM DUAL
  </code></pre>
  
  <p>Since there are some entries within the statement that are duplicates of those already in the database, the whole insert fails and none of the rows are inserted.</p>
  
  <p>Is there a way to ignore the cases where the unique constraint fails, and just insert the ones that are unique, without having to split it up into individual INSERT statements?</p>
  
  <p><strong>Edit:</strong> I realised I probably don't want to do this anyway, but I'm still curious as to whether it's possible or not.</p>