Oracle序列增删改查管理

表添加序列

create sequence seq_loan_case_recycle /**序列名*/
minvalue 1 /*最小值 */
maxvalue 999999999999999999999999999 /*最大值 */
start with 200 /*开始数值 */
increment by 1 /*每次增加值*/;

查询序列

//查询序列
select hibernate_sequence.nextval from dual;

更改序列

alter sequence hibernate_sequence
increment by 2000000;
 
alter sequence hibernate_sequence
increment by 1;
 
COMMIT ;
 
select hibernate_sequence.nextval from dual;

删序列

drop sequence hibernate_sequence;
 
create sequence hibernate_sequence
minvalue 1
maxvalue 999999999999999999999999999
start with 2000000