SQL> create sequence se_1 start with 1;
序列已创建。
SQL> select se_1.nextval from dual;
NEXTVAL
----------
1
SQL> /
NEXTVAL
----------
2
SQL> /
NEXTVAL
----------
3
SQL> select se_1.currval from dual;
CURRVAL
----------
3
SQL> alter sequence se_1 increment by -2;
序列已更改。
SQL> select se_1.nextval from dual;
NEXTVAL
----------
1
SQL> select se_1.currval from dual;
CURRVAL
----------
1
序列已创建。
SQL> select se_1.nextval from dual;
NEXTVAL
----------
1
SQL> /
NEXTVAL
----------
2
SQL> /
NEXTVAL
----------
3
SQL> select se_1.currval from dual;
CURRVAL
----------
3
SQL> alter sequence se_1 increment by -2;
序列已更改。
SQL> select se_1.nextval from dual;
NEXTVAL
----------
1
SQL> select se_1.currval from dual;
CURRVAL
----------
1