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

ALTER SEQUENCE
DROP SEQUENCE

Related Views:

 DBA_SEQUENCES        ALL_SEQUENCES        USER_SEQUENCES



Back to the Top

Simon Sheppard
SS64.com