Sequences Oracle PLSQL Tutorial

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>