Permissions

You must have "create_sequence" privileges. You must also have the "next" privilege to retrieve values from a defined sequence. For information on the "next" privilege, see Grant (privilege).

Locking and Sequences

In applications, sequences use logical locks that allow multiple transactions to retrieve and update the sequence value while preventing changes to the underlying sequence definition. The logical lock is held until the end of the transaction.

Related Statements

Alter Sequence

Drop Sequence

Examples: Create Sequence

The following are Create Sequence statement examples:

1. Define the start value for sequence "XYZ" as 10.

   create sequence XYZ start with 10

2. Define the increment value for sequence "XYZ" as 10 and the number of cached values as 500.

   create sequence XYZ increment by 10 cache 500