Can you alter start with clause?



Can you alter start with clause?..

Answer / 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

More SQL PLSQL Interview Questions

What does sql stand for?

0 Answers  


What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,


What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,


What is trigger in pl sql?

0 Answers  


What is trigger and types?

0 Answers  






Explain 3 basic parts of a trigger.

0 Answers  


Does view store data in sql?

0 Answers  


Is primary key clustered or nonclustered?

0 Answers  


what is variable in package specification

3 Answers  


How to select 10 records from a table?

0 Answers  


What is the need of a partition key?

0 Answers  


What is difference between joins and union?

0 Answers  


Categories