SQL> createsequence se1 start with 1 maxvalue 100 cycle; --创建序列,从1开始到100后循环
序列已创建。
SQL> selectse1.currval from dual;--需要先nextval!
selectse1.currval from dual
*
第 1 行出现错误:
ORA-08002:序列 SE1.CURRVAL 尚未在此会话中定义
SQL> selectse1.nextval from dual;
NEXTVAL
----------
1
SQL> selectse1.currval from dual;
CURRVAL
----------
1
SQL> selectse1.nextval from dual;
NEXTVAL
----------
2
SQL> dropsequence se1;
序列已删除。
--EOF--