Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: merge statemet

Re: merge statemet

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Mon, 15 May 2006 17:39:18 +0300
Message-ID: <6e49b6d00605150739s5b761ac0j@mail.gmail.com>


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_at_gmail.com>:
> 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_at_gmail.com> wrote:
> >
> > Raj,
> >
> > Take a look at DBA_TAB_MODIFICATIONS.
> >
> > Dennis Williams
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 15 2006 - 09:39:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US