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
- 11379 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
What is the purpose of the partition table?
What is sql analyzer?
Is pl sql useful?
What are the qualities of 2nf?
Explain foreign key in sql?
Can we create foreign key without primary key?
List the ways to get the count of records in a table?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How to rename a column in the output of sql query?
What are tuples in sql?
What is an example of translating a date into julian format?
How do I run sql?
How exception handling is done in advance pl/sql?
What is rowtype?
what is index? : Sql dba
