ORACLE 序列
create sequence 序列名
increment by 1
start with 1
maxvalue 999999999;
drop sequence 序列名
select 序列名.nextval from dual
注意 : 每查询一次,序列按自定义增长;
alter sequence 序列名 increment by -2 修改,值减2 +2=值加2
alter sequence 序列名 increment by 5; 修改,值等于5
ALTER SEQUENCE SEQ_NAME MAXVALUE 9999999999; 修改序列的最大值