There is a sequence with min value 100.
I want to alter this sequence to min value as 101.
If the table has already data in the sequence column as
100,101,102...
Is it possible to do so ?
- 4 Answers
- 11693 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ranvijay
we can only alter MINVALUE,MAXVALYE,Incremented by and
CACHE of sequence.but not alter START WITH.
Alter sequence sequanceName
incremented by 2
minvalue 101;
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Can we rollback truncate?
Can we use distinct and group by together?
what is bcp? When does it used? : Sql dba
How do I remove duplicates in two columns?
Is primary key clustered index?
how to use regular expression in pattern match conditions? : Sql dba
what are all the common sql function? : Sql dba
what is sql server agent? : Sql dba
define sql insert statement ? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is inner join faster than left join?
What is the current version of sql?
What is the best sql course?
what are the advantages of sql ? : Sql dba
what are aggregate and scalar functions? : Sql dba
