用Create Sequence。
例子:
Create Sequence AAA_Seq
Minvalue 1
maxvalue 10000000
start with 1
increment by 1
cache 20;在Enterprise Manager Console可以在sequences处,点右鍵,选New...。
例子:
Create Sequence AAA_Seq
Minvalue 1
maxvalue 10000000
start with 1
increment by 1
cache 20;在Enterprise Manager Console可以在sequences处,点右鍵,选New...。
START WITH 1
MINVALUE 1
MAXVALUE 9999999
INCREMENT BY 1
CYCLE
;
CREATE SEQUENCE RLDBA.CCGCCSBXH
START WITH 47
INCREMENT BY 1
NOMAXVALUE
MINVALUE 1
NOCYCLE
NOCACHE
ORDER;
查看序列的下一值是多少:
使用:SELECT CCGCCSBXH.NEXTVAL FROM DUAL