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
- 11400 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / lova raju allumalla
WE CANNOT ALTER A SEQUENCE START NUMBER BUT IF U WANT TO
CHANGE THE EXISTING DATA IN THE TABLE THEN
ASSUME U HAVE EMPLOYEE TABLE WHERE EMPNO BEGINS WITH 100
UPDATE EMPLOYEE SET EMPNO = EMPNO + 1 WHERE EMPNO IN
(SELECT EMPNO FROM EMPLOYEE);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is meant by truncate in sql?
what is a cursor? : Sql dba
what are all the different types of indexes? : Sql dba
What is write ahead logging in sql server?
Is join same as left join?
What is self-join and what is the requirement of self-join?
How do I write a cron which will run a sql query and mail the results to agroup?
Where is all the data on the internet stored?
what is log shipping? : Sql dba
How do you select unique values in sql?
Can we create a trigger on view?
What is gpt format?
How do I run a sql script?
Can we commit in trigger?
Enlist the data types that can be used in pl/sql?
