1.查看全部序列
select * from user_sequences;
2.创建序列
例一:
CREATE SEQUENCE SEQ_PREENTRY_INFO
INCREMENT BY 1
START WITH 起始
MINVALUE 0
NOCYCLE
CACHE 20
例二:
CREATE SEQUENCE SEQ_PREENTRY_INFO_DJ
INCREMENT BY 1
START WITH 起始值
MINVALUE 0
NOCYCLE
CACHE 20
3.修改序列编号递增数值
ALTER SEQUENCE 序列名 INCREMENT BY 起始值;