Or select count(*) before and after the merge has been run. If you know how
many rows were in the merged set, you can calculate the number of updated &
inserted rows from there.
Tanel.
It seems that either triggers with a counter or some additional column in the table is an option. Although with additional column (and following requery) the very purpose of MERGE statement is somewhat discarded and triggers also isn't performance boosters ;)
Gints
-- //www.freelists.org/webpage/oracle-l