Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11206 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kiran kumar
The START WITH Value can not changed using ALTER SEQUENCE
command. The sequence must be dropped and recreate a
sequence in different number.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Which operator is used in query for pattern matching?
what is the difference between char_length and length? : Sql dba
What is query syntax?
Where do we use pl sql?
What sql database should I use?
what is view? : Sql dba
Can we insert delete data in view?
What is left join in sql?
Explain how exception handling is done in advance pl/sql?
What are different types of indexes?
Are dml statements autocommit?
What are tables and fields in the database?
What does fetching a cursor do?
What is information schema in sql?
Is nosql relational?
