DB-hub Technology Oracle How to set value of a sequence

How to set value of a sequence

Oracle does not let you change the value of a sequence. How to set a value?

create a test sequence:

CREATE SEQUENCE PEACOCK.TEST_SEQ START WITH 100;

SELECT last_number FROM   user_sequences
WHERE  sequence_name = 'TEST_SEQ';

LAST_NUMBER
-----------
100

Change the value:

ALTER SEQUENCE PEACOCK.TEST_SEQ INCREMENT BY -10;
SELECT PEACOCK.TEST_SEQ.NEXTVAL FROM dual;
ALTER SEQUENCE PEACOCK.TEST_SEQ INCREMENT BY 1;

Verify:

SELECT last_number FROM user_sequences
WHERE  sequence_name = 'TEST_SEQ';
LAST_NUMBER
-----------
90

Leave a Reply

您的邮箱地址不会被公开。 必填项已用 * 标注

Related Post