Oracle interview Question - 1. 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? Ans. Sequence name CURRVAL, Sequence name NEXTVAL. It is not possible. Only if you access next value in the session, current value can be accessed. 2. What are CYCLE/NO CYCLE in a Sequence? Ans. CYCLE specifies that the sequence continues to generate values after reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum. NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum value.
Posted on: Mon, 26 Jan 2015 12:44:04 +0000
Trending Topics
Recently Viewed Topics
© 2015