ALTER SEQUENCE

Change the next value of a sequence.

Syntax:

   ALTER SEQUENCE [schema.]sequence_name option(s)

Options:
      INCREMENT BY int
      MAXVALUE int | NOMAXVALUE
      MINVALUE int | NOMINVALUE
      CYCLE | NOCYCLE
      CACHE int | NOCACHE
      ORDER | NOORDER

"Be nice to people on the way up, because you'll meet them on your way down" ~ Wilson Mizner

Related:

CREATE SEQUENCE
DROP SEQUENCE

 DBA_SEQUENCES        ALL_SEQUENCES        USER_SEQUENCES


© Copyright SS64.com 1999-2014
Some rights reserved