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