本文介绍了Oracle数据库中创建序列时使用CYCLE选项的情况。当序列达到MAXVALUE后，由于设置了CYCLE，序列会返回到最小值1并继续递增。在示例中，序列seq1已达到200的最大值，执行nextval后，SELECT语句将显示1。
一、原题
二、题目翻译
Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
The SEQ1 sequence 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
B. 10
C. 100
D. an error
答案：A
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
The SEQ1 sequence 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
B. 10
C. 100
D. an error
答案：A
二、题目翻译
下面的CREATE SEQUENCE语句:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
SEQ1序列已经增长到200的最大值限制，执行下面
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
SEQ1序列已经增长到200的最大值限制，执行下面
最低0.47元/天 解锁文章
扫一扫
9172
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
