Sequance current value for one session?
682732Dec 16 2010 — edited Dec 17 2010Hi,
Can anyone confirm if the following statement is true?
------------------------------------
If there is more then one session using the same sequence at the same time then i only get the current value of my session.
-----------------------------------
I am using oracle 9i and inserting values in two tables. First table will have the sequance nextval and second table will have curval of same sequance. I am wondering if there is another user using the same sequance at the same time then would i get the curval of my session (which i have just added into the first table) or will it be from different session?
Thanks