CREATE SEQUENCE

The Oracle CREATE SEQUENCE statement create an object to generate a number sequence.

The general format is:

CREATE SEQUENCE sequencename
INCREMENT BY n
START WITH n
{MAX VALUE n | NOMAXVALUE}
{MIN VALUE N | NOMINVALUE}
{CYCLE | NOCYCLE}
{CACHE N | NOCACHE}
{ORDER | NOORDER};

Example 1:

CREATE SEQUENCE numinvoice MINVALUE 1 START WITH 1 INCREMENT BY 1 NOCACHE;

Example 2, get next value:

SELECT numinvoice.NEXTVAL FROM DUAL;

returns:

145

Example 3, get current value:

SELECT numinvoice.CURRVAL FROM DUAL;

returns:

145