title: MERGE - When not matched INSERT's exception
body: <p>i have a PL/SQL procedure using MERGE :</p>
  
  <pre><code>MERGE INTO 
    table_dest d
  USING
    (SELECT * FROM my_Table) s
  ON
    (s.id = d.id)
  when matched     then UPDATE set d.col1 = s.col1
  when not matched then INSERT (id, col1) values (s.id, s.col1);
  </code></pre>
  
  <p>now lets say the query <code>s</code> returns mutiple rows with same id wich will returns an <strong>ORA-00001: unique constrain error</strong> </p>
  
  <p>what i want to do is to send the duplicated columns to another table <strong>my_Table_recyledbin</strong> to get a successful INSERT, can i use <code>EXCEPTION WHEN DUP_VAL_ON_INDEX</code> ? if yes how to use it with the MERGE statement?</p>
  
  <p>Thanks in advance</p>