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 dynamic SGA and static SGA

4046


What happens if recursive calls get out of control?

722


How to create a table index in oracle?

850


What is materialized view in Oracle?

813


What is ceil and floor in oracle?

787


Explain the use of rows option in imp command.

775


can anyody please send me the dump for Oracle 10g certifications for DBA path?

1904


Explain oracle insert into command?

833


What is rowid and rownum in oracle?

761


What is a system tablespace and when it is created?

722


What are the advantages of oracle?

748


Difference between inner join vs where ?

776


Is oracle an operator?

688


What is Trigger in Oracle?

773


How to save query output to a local file?

773