CREATE SEQUENCE

Create a sequence.

Syntax:

   CREATE SEQUENCE [schema.]sequence_name option(s)

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

"Never tell people how to do things. Tell them WHAT to do and they will surprise you with their ingenuity." - Gen. George S. Patton, Jr.

Related:

ALTER SEQUENCE
DROP SEQUENCE

 DBA_SEQUENCES        ALL_SEQUENCES        USER_SEQUENCES


© Copyright SS64.com 1999-2013
Some rights reserved