17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select sequence_owner,sequence_name from dba_sequences
2 where sequence_name='ABCD';
SEQUENCE_OWNER SEQUENCE_NAME
------------------------------ ------------------------------
SCOTT ABCD
SQL> CREATE SEQUENCE "SCOTT"."ABCD" INCREMENT BY 1 START WITH 1
2 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
3 CACHE 20 NOORDER;
Sequence created.
SQL> select ABCD.NEXTVAL from dual;
NEXTVAL
----------
1
SQL> select ABCD.NEXTVAL from dual;
NEXTVAL
----------
2
SQL> create sequence abcd_seq increment by 1
2 start with 1
3 maxvalue 1.0E28 minvalue 1 nocycle
4 cache 20 noorder;
序列已创建。
SQL> select abcd_seq.nextval from dual;
1
SQL>
CREATE SEQUENCE ABCD INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
CACHE 20 NOORDER