SEQUENCES
A sequence is a database object used to generate sequence numbers for rows in table. It can be used for producing unique primary key values.
A sequence is created using CREATE SEQUENCE command. It has the following syntax:
CREATE SEQUENCE <sequence name> [INCREMENT BY <N>] [START WITH <N>] [MINVALUE X] [MAXVALUE];