表添加序列
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