Re: merge statemet

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 15 May 2006 22:48:40 +0800
Message-ID: <025e01c6782e$aaae82b0$6401a8c0@porgand>

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.

Original Message ----- From: "Gints Plivna" <gints.plivna_at_gmail.com> To: <rjamya_at_gmail.com> Cc: "oracle-l" <oracle-l_at_freelists.org> Sent: Monday, May 15, 2006 10:39 PM Subject: Re: merge statemet

> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 15 2006 - 09:48:40 CDT