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
- 11411 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
Is sql a microsoft product?
What is the location of pre_defined_functions.
What is the purpose of the primary key?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is the main difference between sql and pl/sql?
How do you concatenate in sql?
How to combine two stored procedures in sql?
What is consistency?
how can we submit a form without a submit button? : Sql dba
Why are cursors used?
What is function and procedure in pl sql?
How does sql developer connect to oracle database?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is mdf ldf and ndf?
