循环使用的序列达到最大值之后（实验）

Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;

The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following
SQL statement:
SELECT seq1.nextval FROM dual?
What is displayed by the SELECT statement?
A. 1

SQL> CREATE SEQUENCE seq1
  2  START WITH 100
  3  INCREMENT BY 10
  4  MAXVALUE 200
  5  CYCLE
  6  NOCACHE;

序列已创建。

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       100

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       110

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       120

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       130

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       140

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       150

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       160

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       170

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       180

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       190

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       200

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
         1

SQL> /

   NEXTVAL
----------
        11

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21256317/viewspace-1061740/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21256317/viewspace-1061740/