ORACLE: ALTER SEQUENCE [EN]
top of page
CerebroSQL

Oracle:

ALTER SEQUENCE

ALTER SEQUENCE [ schema. ] sequence
{ INCREMENT BY integer
| { MAXVALUE integer | NOMAXVALUE }
| { MINVALUE integer | NOMINVALUE }
| { CYCLE | NOCYCLE }
| { CACHE integer | NOCACHE }
| { ORDER | NOORDER }
} ...
;

example

ALTER SEQUENCE customers_seq
MAXVALUE 1500;

ALTER SEQUENCE customers_seq
CYCLE
CACHE 5;

bottom of page