Question

Oracle: What are CYCLE/NO CYCLE in a sequence?

Answer 1

hello dude



When you create a sequence with CYCLE option, you are saying that when the sequence reaches its MAXVALUE, it will start over at the MINVALUE. This is not wise if using the sequence for primary key creation. 
 
When you create a sequence with NOCYCLE option, you are saying that when the sequence reaches its MAXVALUE, it will NOT start over at the MINVALUE. This option is safest if using the sequence for primary key creation. When the sequence reaches its MAXVALUE an oracle error is thrown.

Answer 2

Answer:

a recurrent series of events or processes in plants and animalsa life cycle; a growth cycle; a metabolic cycle. physics a continuous change or a sequence of changes in the state of a system that leads to the restoration of the system to its original state after a finite period of time.

Explanation:

Hope that helps !!!