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
- 11399 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
What's the difference between inner join and left join?
What is a database trigger?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What are the different tcl commands in sql?
What are synonyms in sql?
What is sqlca in powerbuilder?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What are analytical functions in sql?
what is oltp (online transaction processing)? : Sql dba
what are all the different types of indexes? : Sql dba
What is dialect in sql?
What is record data type?
What is a primary key sql?
Why is nosql good?
What is composite primary key in sql?
