1.权限
CREATE SEQUENCE系统权限
2.语法
CREATE SEQUENCE 序列名
[INCREMENT BY n]
[START WITH n]
[{MAXVALUE/ MINVALUE n|NOMAXVALUE}]
[{CYCLE|NOCYCLE}]
[{CACHE n|NOCACHE}];
3.例子
CREATE SEQUENCE my_table_SEQ
INCREMENT BY 1
START WITH 51
MAXVALUE 9999999999999999999999999999 /*28位*/
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER