After the highest possible value for a sequence has been reached,previous values can be reused if the NOCYCLE option has been specified.

Question

Quizplus · Accepted Answer

When the NOCYCLE option is specified for a sequence, it means that the sequence cannot reuse values. Once the maximum value is reached, it will either raise an error or halt issuing new values, depending on the system's settings, but it will not start over or reuse previous values. Cycling of values is only allowed if the CYCLE option is explicitly specified.

After the Highest Possible Value for a Sequence Has Been