Use dual table to check sequence : Create Sequence « Sequence « Oracle PL / SQL






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.

   
  








Related examples in the same category

1.Create a SEQUENCE and retrieve the value
2.If id is null, use the value from sequence
3.CREATE SEQUENCE myTableIDSeq INCREMENT BY 1 START WITH 1000;
4.create sequence emps_seq start with 501 increment by 10