Create Sequence Number

Using sequence number we can generate sequence numbers.

Syntax:
CREATE SEQUENCE <Sequence Name> INCREMENT BY <Increment Number> START <Starting Number> NO CACHE

Example:

CREATE SEQUENCE TEST_SEQ INCREMENT BY 1 START 100 NO CACHE


See Also:

• Alter Sequence 
• Drop Sequence