title: PLSQL: Get number of records updated vs inserted when a merge statement is used
body: <p>Merge will always give you the number of records merged regardless of how my records inserted or updated using SQL%ROWCOUNT.</p>
  
  <p>But how to find out number of records that were actually inserted vs number of records that were actually updated.</p>
  
  <p>I tried options from this post but this doesn't seem to work -</p>
  
  <p><a href="https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:122741200346595110" rel="nofollow">https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:122741200346595110</a></p>
  
  <p>Any help?</p>