What is the difference between CYCLE/NO CYCLE in a oracle Sequence?

Options
- For a cycle values for the column are regenerated MAXVALUE is reached
- For a cycle values for the column are regenerated from MINVALUE once MAXVALUE is reached
- For a no cycle values for the column are regenerated MAXVALUE is reached
- For a no cycle values for the column are regenerated from MINVALUE once MAXVALUE is reached

CORRECT ANSWER : For a cycle values for the column are regenerated from MINVALUE once MAXVALUE is reached

Discussion Board
Difference between CYCLE / NO CYCLE in Oracle Sequence

When a sequence is created using CYCLE option, values for the column are regenerated from MINVALUE once MAXVALUE is reached. Certainly, this option should not be used if the Sequence is created for a primary key column.

When a sequence is created using NO CYCLE option, values for the column are NOT regenerated from MINVALUE once MAXVALUE is reached.

Prajakta Pandit 02-10-2017 04:35 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲