A sequence generator is a database object that provides incremental values within any integer range. You can specify any positive or negative increment. The DataServer supports the Oracle sequence generator. To define Oracle sequences, you use the SQL CREATESEQUENCE statement and indicate the name, minimum and maximum values, increment, and whether numbers are reused. For example, this is the code for creating a sequence named seq-table-name that starts with 1 and increments by 1:
CREATE SEQUENCE seq-table-name START WITH 1 INCREMENT BY 1
Note: Do not define Oracle sequences with names ending in _SEQ unless this manual instructs you to do so. The DataServer uses Oracle sequences whose names end in _SEQ for internal purposes.
