Create Sequence In Oracle

Sequence In Oracle Definition:

You can create for auto increment number/ID creation. Oracle generates sequence of number depend upon our code boundary.

Sequence In Oracle Syntax:

CREATE SEQUENCE SEQUENCE_NAME

        MINVALUE VALUE        ( Assign Minimum Value )

        MAXVALUE VALUE        ( Assign Maximum Value )

        START WITH VALUE    ( Assign Start Value )

        INCREMENT BY VALUE;    ( Assign Increment Value )

Sequence In Oracle Example:

CREATE SEQUENCE DUMMY_SEQUENCE

    MINVALUE 1

    MAXVALUE 10000

    START WITH 1

    INCREMENT BY 1

    CACHE 20;

Sequence Usage:

    DUMMY_SEQUENCE.NEXTVAL

Sequence Inside Query

INSERT INTO DUMMY_PERSONAL_DTLS

(DUMMY_ID,DUMMY_FNAME,DUMMY_LANME)

VALUES

(DUMMY_SEQUENCE.NEXTVAL,'RAJINI','THIYAGARAAJ');