What is CYCLE/NO CYCLE in a Sequence?

Answer Posted / tulsi

NO CYCLE is default when sequence is created

CYCLE statement is given when the sequence has to repeat
its number generation between START WITH and MAX VALUE.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the sql case statement?

746


Is sql better than excel?

697


What is trigger price?

727


What are basic techniques of indexing?

1069


What is sql*plus?

771






How to load data with sql*loader?

739


what is union? : Sql dba

739


How many functions are there in sql?

716


Whis is not false in primary key?

1167


List out the acid properties and explain?

709


Does view contain data?

786


How do you update sql?

707


What are schema-level triggers?

752


What is a behavioral trigger?

689


Explain the difference between triggers and constraints?

704