how to unbreak sequence numbers during intereptions

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to unbreak sequence numbers during intereptions

Question Posted / ga

1 Answers
3753 Views
Ion Exchange, I also Faced
E-Mail Answers

how to unbreak sequence numbers during intereptions..

Answer / sudipta santra

ADDING THE CYCLE KEYWORD.

ALTER SEQUENCE SQ1 CYCLE;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More Oracle General Interview Questions

Explain the relationship among Database, Tablespace and Data file?

What are cursor?where are they used?

How do I start tns listener?

How to view the data files in the current database?

What do you mean by merge in oracle and how can we merge two tables?

How to run queries on external tables?

What is an Extent ?

When can Hash Cluster used ?

What are the various constraints used in oracle?

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

How to view the dropped tables in your recycle bin?

What is oracle in java?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)