Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

CREATE/ALTER/DROP SEQUENCE

Synopsis

CREATE Syntax:

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

ALTER Syntax:

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

DROP Syntax:

DROP SEQUENCE [schema.]sequence_name

Creates, modifies, or removes an Oracle sequence that can be used to automatically generate sequential numbers during database operations. The generation of a sequence number is not affected by the subsequent rollback of the transaction; once generated, that sequence number will not be available again, so gaps can occur. Sequence numbers are accessed by using the pseudocolumns CURRVAL and NEXTVAL.

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

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page