Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Sequences

 

Select deptno_seq currval, deptno_seq nextval

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