SQL (Structured Query Language) Question: Download Questions PDF
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?
Answer:
Sequence name CURRVAL, sequence name NEXTVAL. It is not possible. Only if you access next value in the session, current value can be accessed.
Download SQL Interview Questions And Answers
PDF