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
- 10576 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 plvcmt and plvrb does in pl/sql?
Explain some predefined exceptions.
What does closing a cursor do?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is difference between sql and oracle?
how to create a test table in your mysql server? : Sql dba
what is a table in a database ? : Sql dba
Is oracel sql developer written in java?
What is an inconsistent dependency?
how many values can the set function of mysql take? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How do I tune a sql query?
What is keys and its types?
What is the current version of sql?
how to convert numeric values to character strings? : Sql dba
