Re: CURRVAL in multi-user environments

Matt -

This sounds simple enough to test. Give it a try and answer your own question...

TG

Matthew Nicoll wrote:

> The Oracle documentation I have seen suggests I can define a sequence,
> then use sequence_name.NEXTVAL for an ID for a parent row,
> then use sequence_name.CURVAL in subsequent writes to child rows.
>
> In a multi-user environment, if the order of events is:
> User 1 - NextVal gets 100
> User 2 - NextVal gets 101
> User 1 - CurrVal gets 100 or 101?
>
> I.e. is Oracle smart enough to keep a different CURRVAL for
> each user?
Received on Tue May 21 2002 - 18:39:51 CDT