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
- 11409 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
Is pl sql still used?
What is meant by cursor in sql?
Does google use sql?
What is difference between sql and mysql?
What is the difference between pl and sql?
How do I create a sql script?
What is varchar sql?
define sql delete statement ? : Sql dba
What are the types of subqueries?
Is left join same as inner join?
What is sp_helptext?
Explain autonomous transaction.
What are sql indexes?
What is oracle pl sql developer?
What is asqueryable?
