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

Previous QuestionNext Question
If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?Can a view be updated/inserted/deleted? If Yes - under what conditions?