CURRVAL in multi-user environments

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:25:19 CDT