Топ-100
 

ALTER SEQUENCE

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

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;