17,377
社区成员
发帖
与我相关
我的任务
分享把ID字段从1开始重新递增赋值，应该怎么做呢？
一张表格中有字段ID，数据类型为number,ID的数值不是依次递增的，有些间隔很大，比如，ID有值为77的，也有值为97的，但77和97之间的都没有，现在我要把这些ID从1开始重新递增赋值，应该怎么做呢？
...全文
请发表友善的回复…
发表回复
dddd8888 2003-08-19
- 打赏
- 举报
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;
/
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;
/
lynx1111 2003-08-19
- 打赏
- 举报
http://expert.csdn.net/Expert/topic/1951/1951548.xml?temp=.1000482
