Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Sequences

 

Query current sequence value

SQL> SQL> create sequence deptno_seq start with 50 increment by 10; Sequence created. SQL> SQL> select deptno_seq.currval   2  from   dual; select deptno_seq.currval        * ERROR at line 1: ORA-08002: sequence DEPTNO_SEQ.CURRVAL is not yet defined in this session SQL> SQL> drop sequence deptno_seq; Sequence dropped. SQL>