How to use sequence and what use of sequence cache?
Seqences are often used to generate autonumber fields. A sequence is an object in Oracle used to create a number sequence, often used to create a primary key column.
Syntax:CREATE SEQUENCE sequenceName
MINVALUE value
MAXVALUE value
START WITH value
INCREMENT BY value
CACHE value;
Sequence CACHE is used to cache up to n values for performance. However, in case of a system failure, all cached sequence values are lost and remain unused.
