DATABASE SEQUENCE NOTES:

Owner - Owner of the sequence

Name - Name of the sequence

MinValue - Minimum value of the sequence

MaxValue - Maximum value of the sequence

Increment - Value by which sequence is incremented

Cycle - Does sequence wrap around on reaching limit?

Order - Are sequence numbers generated in order?

Cache Size - Number of sequence numbers to cache

Last Number - Last sequence number written to disk

Sequences are special database objects that provide numbers in sequence for input to a table. They are useful for providing generated unique key values and input of number type columns such as purchase order, employee number, sample number, sales order number, where the input must be unique and in numerical sequence.