SQL> select exam_sequence.nextval from exam;
NEXTVAL
----------
83
84
85
86
87
SQL> select exam_sequence.currval from exam;
CURRVAL
----------
103
103
103
103
103
103
exam表中有6条数据存在,但是和nextval,currval有什么关系?
NEXTVAL
----------
83
84
85
86
87
SQL> select exam_sequence.currval from exam;
CURRVAL
----------
103
103
103
103
103
103
exam表中有6条数据存在,但是和nextval,currval有什么关系?
补充
SQL> select exam_sequence.nextval from exam;
NEXTVAL
----------
83
84
85
86
87如果6条记录,这个结果集差一条,还有个88