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
- 11414 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 range partitioning?
Explain exception handling in pl/sql?
What is dba in sql? : SQL DBA
Can a foreign key have a different name?
What is the difference among union, minus and intersect?
What are the types of operators available in sql?
Can we join 3 tables in sql?
Can two tables have same primary key?
Is join an inner join?
How can we avoid duplicating records in a query?
What is spool?
How does postgresql compare to mysql?
How can we implement rollback or commit statement in a trigger?
What is an exception in pl/sql?
What is the difference between nvl function, ifnull function, and isnull function?
