top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+1 vote
134 views
Oracle: What are CYCLE/NO CYCLE in a sequence?
posted Sep 3, 2015 by Viswas Kumar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Sep 4, 2015 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...