Alter sequence increment

 Alter sequence increment

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>


Note:-Please comment and reply me.