SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

count for inserted and updated records in a merge statement

508434Jul 18 2006 — edited Jul 18 2006

Hi,

I am using a merge statement in PL/SQL and I need number of records inserted and number of records updated by that particular merge statement. We have
%rowcount for any other DML operations to find out the number of records affected. Please advise me how to find out these details from the target table.

Poulose

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 15 2006

Added on Jul 18 2006

5 comments

1,551 views