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

What are the advantages of sql? Explain

641


what is a primary key? : Sql dba

548


What is embedded sql in db2?

501


What is a full join?

519


How many subqueries can be nested in a statement?

500






What is embedded sql with example?

537


Why do we create views in sql?

547


explain commit and rollback in mysql : sql dba

537


Why we use sql profiler?

555


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

609


How do I filter in sql profiler?

530


What is the difference between a subquery and a join?

521


What is a column in a table?

546


How do I tune a sql query?

508


Explain scalar functions in sql?

574