DROP SEQUENCE aa; CREATE SEQUENCE aa START WITH 100; 也行吧
要实现这个功能只要自己写一个过程(或者函数)就可以了:create or replace procedure move_max(start_value number,step_value number) as min_value int; max_value int; declare min_value start_value; select max() into max_value from your_table; while min_value<=max_value loop min_value:=min_value + step_value; select your_sequence.nextval from dual; end loop; end move_max;
CREATE SEQUENCE aa START WITH 100;
也行吧
min_value int;
max_value int;
declare
min_value start_value;
select max() into max_value from your_table;
while min_value<=max_value loop
min_value:=min_value + step_value;
select your_sequence.nextval from dual;
end loop;
end move_max;