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

How will you make performance better for application including front end and back

2 Answers   Metric Stream,


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  


What is a primary key? Explain

0 Answers  


What does sign mean sql?

0 Answers  


Explian rowid, rownum?

0 Answers  






Does sql profiler affect performance?

0 Answers  


What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,


what are date and time intervals? : Sql dba

0 Answers  


What is a sql profiler?

0 Answers  


how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,


What is union?

0 Answers  


Whis is not false in primary key?

0 Answers   Fintellix,


Categories