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
How to rename a column in the output of sql query?
What are sql constraints?
How can you fetch first 5 characters of the string?
what is a field in a database ? : Sql dba
Where is sql database stored?
how to write date and time literals? : Sql dba
Does view store data in sql?
What is trigger in sql? Explain
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Can a foreign key be a duplicate?
Can we create clustered index without primary key?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
what are all different types of collation sensitivity? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?