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