WE CANNOT ALTER A SEQUENCE START NUMBER BUT IF U WANT TO CHANGE THE EXIST

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 ?

Question Posted / lova raju allumalla

4 Answers
11198 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

Please Help Members By Posting Answers For Below Questions

how to shut down the server with 'mysqladmin'? : Sql dba

954

What is the use of non clustered index?

925

What is consistency?

1060

What are sql procedures?

961

Enlist the characteristics of pl/sql?

1735

Can I create table without primary key?

937

What is sql partition?

1035

What is pivot query?

1013

What is sql engine in oracle?

924

How do I clear the screen in sql plus?

978

What is execute immediate?

1001

What is the use of sql trace?

891

What is sql profiler in oracle?

1012

what is oltp (online transaction processing)? : Sql dba

1010

Are dml statements autocommit?

980