Oracle: What are CYCLE/NO CYCLE in a sequence?
Answers
Answered by
0
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.
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.
Answered by
0
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 !!!
Similar questions