What is CYCLE/NO CYCLE in a Sequence ?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
581. What is CYCLE/NO CYCLE in a Sequence ?
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.
(Continued on next question...)
Other Interview Questions