Oracle PL/SQL/Sequence/Alter Sequence

Alter sequence increment

   <source lang="sql">

SQL> SQL> SQL> SQL> CREATE SEQUENCE mySequence

 2      MINVALUE 1
 3      MAXVALUE 999999999999999999999999999
 4      START WITH 1
 5      INCREMENT BY 1
 6      CACHE 20;

Sequence created. SQL> SQL> select mySequence.nextval from dual;

  NEXTVAL

---

        1

SQL> select mySequence.nextval from dual;

  NEXTVAL

---

        2

SQL> select mySequence.nextval from dual;

  NEXTVAL

---

        3

SQL> select mySequence.nextval from dual;

  NEXTVAL

---

        4

SQL> SQL> alter sequence mySequence

 2      increment by 124;

Sequence altered. SQL> SQL> select mySequence.nextval from dual;

  NEXTVAL

---

      128

SQL> SQL> alter sequence mySequence

 2      increment by 1;

Sequence altered. SQL> SQL> select mySequence.nextval from dual;

  NEXTVAL

---

      129

SQL> SQL> SQL> drop sequence mySequence; Sequence dropped. SQL> SQL>

      </source>