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
- 11566 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
Which is better cte or subquery?
What is a procedure in pl sql?
What is difference between inner join and self join?
what is user defined functions? : Sql dba
Explain the structure of pl/sql in brief.
Does inner join remove duplicates?
Does a primary key have to be a number?
What is database migration?
define sql update statement ? : Sql dba
Is it possible for a table to have more than one foreign key?
What is clustered index sql?
Explain alias in sql?
What is consistency?
How does join work in sql?
What are the two different parts of the pl/sql packages?
