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
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