O'Reilly logo

Oracle SQL: the Essential Reference by David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required