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 are all the different normalization?

0 Answers  


What is posting?

0 Answers  


What are user defined functions?

0 Answers  


What is magic table?

6 Answers  


What is self-join and what is the requirement of self-join?

0 Answers  






What are secondary keys?

0 Answers  


cursor types? explain with example programs?

1 Answers   HP,


Explain what is a column in a table?

0 Answers  


State few characteristics of pl/sql?

0 Answers  


how to do backup entire database? : Transact sql

0 Answers  


What is linq to sql?

0 Answers  


if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,


Categories