title: Oracle - Output number of rows affected from dynamic merge statement
body: <p>I have a dynamic sql in a stored procedure with a <code>MERGE</code> statement and and executing it using <code>EXECUTE IMMEDIATE &lt;dynamic_sql&gt;</code>. When I run the merge query through the sql worksheet, it tells me the number of rows merged. How do I retrieve the same information through a dynamic sql?</p>
  
  <p>I would appreciate any efforts towards this question.</p>