Oracle How to count total number of rows inserted in a plsql block
<p>I want to count no of inserts I make into the database</p>

<p>The below query returns one(1) although 2 rows did update </p>

<pre><code>begin 
   Insert into APPLICATIONS (ID,ALIAS,NAME,STATUS) 
        values (1000000386,'BB','Branch Budgets','I'));
   Insert into APPLICATIONS (ID,ALIAS,NAME,STATUS) 
        values (1000000257,'TIME','Timesheets','I'));
   dbms_output.put_line('No Of rows'||sql%Rowcount);
 end;
</code></pre>