Alter sequence increment
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>