oracle中的序列怎么让它重新从1开始记？？

[yhm66]

现在是程序测试，想清空数据，从1 开始？怎么办？

[bzszp]

//重置sequence值
declare
n number(10);
tsql varchar2(100);
begin
select my_seg.nextval into n from dual;
n:=-(n-1);
tsql:='alter sequence my_seg increment by'|| n;
execute immediate tsql;
select my_seg.nextval into n from dual;
tsql:='alter sequence my_seg increment by 1';
execute immediate tsql;
end;
/

[gladness]

drop sequence 序列名;
create sequence 序列名;
缺省就是从一开始

[xu_guanghui]

直接修改SEQUENCE 的START WITH 从1开始就可以了

[Michaelyfj]

建议采用gladness(gladness)的方法做，很方便

[glucose]

好像只能drop,其他方法都会出错

[beckhambobo]

alter SEQUENCE eseq INCREMENT BY 当前最大值-1;
slect eseq.nextval from dual;
alter SEQUENCE eseq INCREMENT BY 1;