Re: merge statemet

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: <gints.plivna@xxxxxxxxx>, <rjamya@xxxxxxxxx>
  • Date: Mon, 15 May 2006 22:48:40 +0800

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@xxxxxxxxx>
To: <rjamya@xxxxxxxxx>
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
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 

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006