Re: merge statemet

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: rjamya@xxxxxxxxx
  • Date: Mon, 15 May 2006 17:39:18 +0300

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

2006/5/15, rjamya <rjamya@xxxxxxxxx>:
Dennis,

I can't rely on that because table is concurrently modified by others
at the same time, even in development environment.

Raj

On 5/15/06, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:
>
> Raj,
>
> Take a look at DBA_TAB_MODIFICATIONS.
>
> Dennis Williams
>
--
//www.freelists.org/webpage/oracle-l



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


Other related posts: