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

How to order siblings in oracle hierarchy queries?

771


what are the non-standard sql commands supported by 'mysql'? : Sql dba

776


How to get help at the sql prompt?

831


Why do we need view in sql?

730


what are the advantages of sql ? : Sql dba

739






What is PL/SQL Records?

820


Does truncate table reset auto increment?

722


How to execute a stored procedure?

757


what are the differences between binary and varbinary? : Sql dba

720


What is string join?

746


Can we join 3 tables in sql?

707


How many postgresql users are there, worldwide?

779


what is denormalization. : Sql dba

768


Are stored procedures faster than queries?

697


What is prepared statement in sql?

750