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 Commands:

CREATE SEQUENCE
DROP SEQUENCE

Related Views:

 DBA_SEQUENCES        ALL_SEQUENCES        USER_SEQUENCES



Back to the Top

Simon Sheppard
SS64.com