Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / Q: What is CYCLE/NO CYCLE in a Sequence ?

Q: What is CYCLE/NO CYCLE in a Sequence ?
Print
Email to friend
Add comment
Views: 598
Votes: 1
Comments: 0
A: CYCLE specifies that the sequence continues to generate values after reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum.NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum value.  
 
Others in this Category
document How to find tables without Indexes?
document Q: Which is more faster - IN or EXISTS?
document What is a table called, if it has neither Cluster nor Non-cluster Index? What is it used for?
document What is Dirty Read ?
document Q: What is difference between TRUNCATE & DELETE ?
document What is CHECK Constraint?
document What is PRIMARY KEY?
document What does TOP Operator Do?
document What is MERGE Statement?
document What is XML Datatype?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)