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

what is foreign key?

how to handle exceptions in post production

What does ROLLBACK do ?

Write a simple Store procedure and pass parameter to it ?

Is primary key = unique key,not null? If yes,please explain IF No,please explain

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

How to work with data objects interactively?

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

12 RULES OF RDBMS

Who developed oracle & when?

How to delete multiple rows from a table in oracle?

How to export your connection information to a file?

For more Oracle General Interview Questions Click Here