Altering an existing sequence : Alter Sequence « Sequences « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Sequences
3. Alter Sequence

SQL>
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>
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>
SQL>
SQL> DROP SEQUENCE test_seq;

Sequence dropped.

SQL>