<div>
That was the one option I had considered, however, I was wondering if there was another way to handle it. &nbsp;Perhaps there is a function like sql%rowcount that counts inserts or updates?
</div>


That was the one option I had considered, however, I was wondering if there was another way to handle it.  Perhaps there is a function like sql%rowcount that counts inserts or updates?

<div>
<div class="content wysiwyg-content">
I have the following merge statement that either inserts a new record OR updates a record. &nbsp;Then it prints out the number of rows merged.<br />
<br />
I want to be able to print out BOTH number of rows inserted and number of rows updated. &nbsp;Is there a way to do this, and how would it be done?<br />
<br />
MERGE INTO dm_table dm<br />
&nbsp; &nbsp; &nbsp; USING (SELECT *<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM mytable &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE status_ = c_load_stat_new) dmld<br />
&nbsp; &nbsp; &nbsp; ON (dm.id= dmld.dm_physician_id)<br />
&nbsp; &nbsp; &nbsp; WHEN MATCHED THEN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;UPDATE<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SET a =a1<br />
&nbsp; &nbsp; &nbsp; WHEN NOT MATCHED THEN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;INSERT<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (a)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUES<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (a1);<br />
&nbsp; &nbsp; &nbsp; dbms_output.put_line(to_ch<wbr />ar(SQL%ROW<wbr />COUNT) || ' rows merged.');<br />
&nbsp; &nbsp; &nbsp; --<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COMMIT;
</div>
</div>


I have the following merge statement that either inserts a new record OR updates a record.  Then it prints out the number of rows merged.

I want to be able to print out BOTH number of rows inserted and number of rows updated.  Is there a way to do this, and how would it be done?

MERGE INTO dm_table dm
      USING (SELECT *
               FROM mytable              WHERE status_ = c_load_stat_new) dmld
      ON (dm.id= dmld.dm_physician_id)
      WHEN MATCHED THEN
         UPDATE
            SET a =a1
      WHEN NOT MATCHED THEN
         INSERT
            (a)
         VALUES
            (a1);
      dbms_output.put_line(to_char(SQL%ROWCOUNT) || ' rows merged.');
      --
            COMMIT;

PL/SQL MERGE STATEMENT.  I need a count of both inserted and updated rows.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.