Question: 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.