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
- 11383 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
How is indexing done in search engines?
What is the use of sqlerrd 3?
What are the usages of sql?
What is trigger explain it?
What is java sql drivermanager?
How do you update a value in sql?
what is commit? : Sql dba
Is record in oracle pl sql?
How do I write a cron which will run a sql query and mail the results to agroup?
What is the difference between clustered and non-clustered index in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is the use of pl/sql table?
How many types of triggers are there in pl sql?
Why is a trigger used?
who introduced sql?
