1、把当前序列自增量变为N alter sequence S_T_PG_BUS_COLLAGE_HEAD increment by N; 2、更新当前序列值 select S_T_PG_BUS_COLLAGE_HEAD.NEXTVAL from dual; 3、把当前序列自增量变为原来1 alter sequence S_T_PG_BUS_COLLAGE_HEAD increment by 1;