Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Sequences

 

Altering an existing sequence

SQL> SQL> CREATE SEQUENCE test_seq; Sequence created. SQL> SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          1 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          2 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          3 SQL> SQL> ALTER SEQUENCE test_seq MAXVALUE 10; Sequence altered. SQL> SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          4 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          5 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          6 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          7 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          8 SQL> SELECT test_seq.nextval FROM DUAL;    NEXTVAL ----------          9 SQL> SQL> DROP SEQUENCE test_seq; Sequence dropped. SQL>