Well you where correct, this is the answer of a metalink user:

user_seq.CURRVAL (with two R's) is the last number that was assigned in your
session. Even if records are added in other sessions, your CURRVAL remains
the same. Try it. Open two SQL*Plus windows (you can even use the same
username) and see that CURRVAL in one remains the same even while CURRVAL in
the other increases.


Thanks all, and sorry for the out the topic question

Reply via email to