Mega Code Archive

 

Categories / Oracle PLSQL / Sequence

 

Use dual table to check sequence

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.