SQL>
SQL> CREATE SEQUENCE test_seq;
Sequence created.
SQL>
SQL> SELECT test_seq.nextval FROM dual;
NEXTVAL
----------
1
SQL>
SQL> SELECT test_seq.currval FROM dual;
CURRVAL
----------
1
SQL>
SQL> drop sequence test_seq
2 /
Sequence dropped.
SQL>