创建序列
create sequence COMMON_SEQUENCE(序列名)
设置自增值,每次调用数值都增加10000
ALTER SEQUENCE COMMON_SEQUENCE INCREMENT BY 10000; 调用一次 SELECT COMMON_SEQUENCE.NEXTVAL FROM DUAL; 再将自增值设置为1 ALTER SEQUENCE COMMON_SEQUENCE INCREMENT BY 1;
创建序列
create sequence COMMON_SEQUENCE(序列名)
设置自增值,每次调用数值都增加10000
ALTER SEQUENCE COMMON_SEQUENCE INCREMENT BY 10000; 调用一次 SELECT COMMON_SEQUENCE.NEXTVAL FROM DUAL; 再将自增值设置为1 ALTER SEQUENCE COMMON_SEQUENCE INCREMENT BY 1;