Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Sequences

 

CREATE SEQUENCE test_seq

Sequence created. SQL> SQL> SELECT test_seq.nextval FROM dual;    NEXTVAL ----------          1 SQL> SELECT test_seq.currval FROM dual;    CURRVAL ----------          1 SQL> SELECT test_seq.nextval FROM dual;    NEXTVAL ----------          2 SQL> SQL> ALTER SEQUENCE test_seq   2  INCREMENT BY 2; Sequence altered. SQL> SQL> SELECT test_seq.nextval FROM dual;    NEXTVAL ----------          4 SQL> SELECT test_seq.currval FROM dual;    CURRVAL ----------          4 SQL> SELECT test_seq.nextval FROM dual;    NEXTVAL ----------          6 SQL> SQL> drop sequence my_seq; SQL>