drop sequence SRBZ.SEQ_XXX;
create sequence SRBZ.SEQ_XXX
increment by 1
start with 1
nomaxvalue
minvalue 1
nocycle
order;
其中
nomaxvalue:等同于seq创建后的“9999999999999999999999999999”
nocycle:代表不周期循环,cycle(勿使用)为周期循环
drop sequence SRBZ.SEQ_XXX;
create sequence SRBZ.SEQ_XXX
increment by 1
start with 1
nomaxvalue
minvalue 1
nocycle
order;
其中
nomaxvalue:等同于seq创建后的“9999999999999999999999999999”
nocycle:代表不周期循环,cycle(勿使用)为周期循环