Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Sequences

 

Create sequence deptno_seq start with 50 increment by 10

SQL> SQL> create sequence deptno_seq 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> drop sequence deptno_seq; Sequence dropped. SQL>