What is CYCLE/NO CYCLE in a oracle Sequence?

What is CYCLE/NO CYCLE in a 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.
Difference between a hot backup and a cold backup in oracle.
A cold backup is done when there is no user activity going on with the system......
Difference between the SQL*Loader and IMPORT utilities.
SQL*Loader can be used to load data from Delimiter separated files and fixed or variable width text....
What is Bitmapped indexes? What is b-tree index in oracle?
In a Bitmap index, a 2 dimensional array is created. The array represents the index value multiplied by number of rows...
Post your comment

Related Content

Follow us

▲