130821生成序列

最新推荐文章于 2024-07-26 14:08:24 发布

calvin82

最新推荐文章于 2024-07-26 14:08:24 发布

阅读量368

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/calvin82/article/details/10150861

版权

SQL 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

SQL> create sequence test2_seq start with 10 increment by -1 minvalue 1 maxvalue 10 cycle cache 5;

Sequence created

SQL> select * from user_sequences;

SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY CYCLE_FLAG ORDER_FLAG CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ ---------- ---------- ---------- -----------

TEST2_SEQ 1 10 -1 Y N 5 10

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
10

SQL> select test2_seq.currval from dual;

CURRVAL
----------
10

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
9

SQL> select test2_seq.currval from dual;

CURRVAL
----------
9

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
8

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
7

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
6

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
5

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
4

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
3

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
2

SQL> select test2_seq.nextval from dual;

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

SQL> select test2_seq.nextval from dual;

NEXTVAL
----------
10

循环回10；依次递减；

使用序列插入表：

SQL> create sequence order_status2_id_seq nocache start with 1 increment by 1 minvalue 1;

Sequence created

SQL>
SQL> insert into calvin.order_status2(
2 id,status,last_modified)
3 values (
4 order_status2_id_seq.nextval,'PLACED',sysdate);

1 row inserted

SQL> select * from calvin.order_status2;

ID STATUS LAST_MODIFIED
--------------------------------------- ---------- -------------
2 PLACED 2013/8/21 16: