How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
566. How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?
Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.
(Continued on next question...)
Other Interview Questions
|