SEQUENCE

CREATE SEQUENCE id_seq

    INCREMENT BY 10

    START WITH 10

    MINVALUE 10

    MAXVALUE 100

    CYCLE

    CACHE 2;

SELECT

    id_seq.NEXTVAL

FROM

    dual;

SELECT

    id_seq.CURRVAL

FROM

    dual;

alter sequence id_seq nomaxvalue;