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
- 9967 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
Explain spool.
How do I start pl sql?
What is a dynamic query?
How do I sort a table in sql?
How to use boolean type in select statement?
What is a call statement? Explain with an example.
What are packages in pl sql and also explain its advantages?
What is the max nvarchar size?
How to prepare for oracle pl sql certification?
How do I remove all records from a table?
How much does sql certification cost?
Explain 3 basic parts of a trigger.
Is mariadb a nosql database?
What is the process of copying data from table a to table b?
Can we use the cursor's to create the collection in PL/SQL?
