通过Increment By来实现修改初始值。
select 1-1000000000017 from dual; --1是想设置的初始值, 1000000000017当前值
alter sequence SEQ_OID increment by -1000000000016; 想设置的初始值-当前值
select SEQ_OID.nextval from dual;
alter sequence SEQ_OID increment by 1; 递增步长
通过Increment By来实现修改初始值。
select 1-1000000000017 from dual; --1是想设置的初始值, 1000000000017当前值
alter sequence SEQ_OID increment by -1000000000016; 想设置的初始值-当前值
select SEQ_OID.nextval from dual;
alter sequence SEQ_OID increment by 1; 递增步长