Re: many inserts into a table

W artykule <f0bf3cc3.0307312022.3024da58_at_posting.google.com>, Daud napisał(a):

> oracle 8.1.7.4 (OPS environment)
>
> Ok...pls help me out on this one.
> I have one table where there can be many inserts per second. I need to
> know the order of the inserts. I cannot use date because the
> resolution is up to seconds only and I have tested
> dbms_utility.get_time and it wont work too. This will be in an OPS
> environment so, I guess sequence is out (I heard sequence is bad in
> OPS). So, what else can I do? If anyone has some sample codes to
> share, that will be great.

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

-- 
                                   *************************
Marcin 'PIORO' Przepiórowski       *    BORN TO BE WILD    *
                                   *************************