CREATE/ALTER/DROP SEQUENCE
						
						
						
						CREATE SEQUENCE [schema.]sequence_name 
  [INCREMENT BY integer]
  [START WITH integer]    
  [MAXVALUE integer | NOMAXVALUE]
  [MINVALUE integer | NOMINVALUE]
  [CYCLE | NOCYCLE]
  [CACHE integer | NOCACHE]
  [ORDER | NOORDER]

Creates an Oracle sequence that can be used to automatically generate sequential numbers during database operations.

ALTER SEQUENCE [schema.]sequence_name 
  [INCREMENT BY integer]
  [MAXVALUE integer | NOMAXVALUE]
  [MINVALUE integer | NOMINVALUE]
  [CYCLE | NOCYCLE]
  [CACHE integer | NOCACHE]
  [ORDER | NOORDER]

Changes the characteristics of an Oracle sequence, including range, number of sequence numbers cached in memory, and whether sequential order is preserved.

DROP SEQUENCE [schema.]sequence_name

Removes a sequence from the database.

The DROP SEQUENCE and CREATE SEQUENCE commands can be issued sequentially to restart a sequence at a lower number. However, all GRANTs to the sequence will also have to be recreated.

Keywords

INCREMENT BY

Specifies the increment between sequence numbers and can be positive or negative (but not 0). The default is 1.

START WITH

Specifies the first sequence number to be generated. The default is the MINVALUE for ascending sequences and MAXVALUE for descending sequences.

MAXVALUE

Specifies the largest value the sequence number can reach. The default is NOMAXVALUE, which means the maximum value is 1027.

MINVALUE

Specifies the ...

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.