Can you alter start with clause?

Answer Posted / ashok

No.....When altering a sequence,
MAXVALUE, INCREMENT BY, CACHE, CYCLE can be altered as we wish
But Startwith we cant alter
and also Minvalue should not be altered less than seq.CURRVAL

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain ttitle and btitle.

742


does sql support programming? : Sql dba

683


What is offset and limit in sql?

644


Can you select everything, but 1 or 2 fields, without writer's cramp?

589


Is it possible to create the following trigger: before or after update trigger for each row?

822






When are we going to use truncate and delete?

627


What does over partition by mean in sql?

626


What is oracle and pl sql?

753


How exception is different from error?

648


How does an execution block start and end in pl sql?

583


What is sqlcontext?

627


Explain the difference between sql and mysql.

660


How many types of keys are there in sql?

663


Can we use loop in sql?

627


What are the different types of a subquery?

609