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 CREATE SEQUENCE 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