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
START WITH value
INCREMENT BY 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.