SQL>
SQL> create sequence deptno_seq
2 start with 50 increment by 10;
Sequence created.
SQL>
SQL> select deptno_seq.nextval, deptno_seq.currval
2 from dual;
NEXTVAL CURRVAL
---------- ----------
50 50
SQL>
SQL> select deptno_seq.currval
2 from dual;
CURRVAL
----------
50
SQL>
SQL> select deptno_seq.currval, deptno_seq.nextval
2 from dual;
CURRVAL NEXTVAL
---------- ----------
60 60
SQL>
SQL>
SQL> drop sequence deptno_seq;
Sequence dropped.
|