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


Please Help Members By Posting Answers For Below Questions

What is an oracle user account?

585


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1442


How to use windows user to connect to the server?

536


How translate command is different from replace?

550


What is the difference between a hot backup and a cold backup in oracle?

579






Explain an exception and its types?

611


How to create a new table in your schema?

613


what are bitmap indexes? How does they work?

1721


What is Data Dictionary Cache in Oracle?

664


How to start a new transaction in oracle?

593


What is oracle datasource?

557


What is the scope of a local variable?

587


Explain about integrity constraint?

606


Is there an oracle sql query that aggregates multiple rows into one row?

548


can u plz provide me oca sql dumps please i need them

1470