how to unbreak sequence numbers during intereptions
Answer Posted / sudipta santra
ADDING THE CYCLE KEYWORD.
ALTER SEQUENCE SQ1 CYCLE;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is ordinary table in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the sid in oracle?
What is the quickest way to fetch the data from a table?
Can sub procedure/function be called recursively?
Give the advantages and disadvantages of clusters.
What is the difference between Delete, Truncate and Drop in Oracle?
What are the parameters that we can pass through a stored procedure?
How view is different from a table?
How to list all tables in your schema?
What is a system tablespace and when it is created?
Explain the use of tables option in exp command.
Explain the use of show option in imp command.
What is transport network substrate (tns) in oracle?
How to delete a user account in oracle?