SQL Sequences
December 23, 2009
SQL Sequences Introduction:
The use of sequence is very important in Oracle. A sequence is a database item that generates a sequence of integers. It is a set of integers that are used to create a unique number to act as a primary key.
Sytax of an Oracle Sequence
The syntax for a sequence is:
CREATE SEQUENCE sequence_name
MINVALUE value
MAXVALUE value
START WITH value
INCREMENT BY value
CACHE value;
