how to unbreak sequence numbers during intereptions

Question Posted / ga

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

More Oracle General Interview Questions

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

Who i will insert 1 lacks record in a Database table

How to define and use table alias names in oracle?

How to check your oracle database 10g xe installation?

Explain the use of constraints option in exp command.

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

What happens if you lost a data file?

How are Indexes Update ?

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

Explain 1st, 2nd, 3rd normalization form of data base

Select the Nth lowest value from a table?

How many categories of data types in oracle?

For more Oracle General Interview Questions Click Here