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
- 11418 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pradeep
Or other way around can be rename the current sequence and
create new sequence with the desired values;
SQL> CREATE SEQUENCE SEQ_TET INCREMENT BY 1 START WITH 100
MAXVALUE 1000000 MINVALUE 99;
Sequence created.
SQL> rename SEQ_TET to seq_test;
Table renamed.
SQL> select * from user_sequences;
SEQUENCE_NAME MIN_VALUE MAX_VALUE
INCREMENT_BY C O CACHE_SIZE
------------------------------ ---------- ---------- -------
----- - - ----------
LAST_NUMBER
-----------
SEQ_TEST 99
1000000 1 N N 20
100
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sql performance tuning?
Which are the different types of indexes in sql?
What is scalar function in sql?
Which table is left in join?
How do I count records in sql?
Are subqueries faster than joins?
What is a sql select statement?
What is a memo field?
How many clustered indexes can you have?
What is database sql?
What is primary key and foreign key with example?
What is having clause in sql?
What is cross join example?
What is the difference between union and union all command?
What do you mean by stored procedures? How do we use it?
