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
- 11562 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
Does google use sql?
what is self-join? : Sql dba
What is write ahead logging in sql server?
List the various privileges that a user can grant to another user?
How many sql commands are there?
How to fix oracle error ora-00942: table or view does not exist
How insert into statements in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
Enlist the advantages of sql.
What is cursor and its types?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What are sql data types?
Why triggers are used?
What is sql*plus?
Does sql full backup truncate logs?
