Re: many inserts into a table

This is interesting....not sure if it will work but will give it a try. Need to check the performance as well!

thanks
Daud

Marcin P <pioro1_at_poczta.fm> wrote in message news:<slrn.pl.bik99p.1l1.pioro1_at_laptop.pioro>...
> W artykule <f0bf3cc3.0307312022.3024da58_at_posting.google.com>, Daud napisał(a):
>
>
> If each insert is in another transaction, you can use
> insert into t values (value, userenv('commitscn'));
>
> when you select this table after the commit, in second columne you may
> see scn number, which is increasing to each transaction.
>
> regards,
>
>
> Pozdrawiam
Received on Fri Aug 01 2003 - 10:28:41 CDT