Sequence created.
SQL>
SQL> SELECT test_seq.nextval FROM dual;
NEXTVAL
----------
1
SQL> SELECT test_seq.currval FROM dual;
CURRVAL
----------
1
SQL> SELECT test_seq.nextval FROM dual;
NEXTVAL
----------
2
SQL>
SQL> ALTER SEQUENCE test_seq
2 INCREMENT BY 2;
Sequence altered.
SQL>
SQL> SELECT test_seq.nextval FROM dual;
NEXTVAL
----------
4
SQL> SELECT test_seq.currval FROM dual;
CURRVAL
----------
4
SQL> SELECT test_seq.nextval FROM dual;
NEXTVAL
----------
6
SQL>
SQL> drop sequence my_seq;
SQL>