deaclare c_id number; c_rn number; begin c_id:=1; c_rn:=1; loop update table set id=c_id where 主键列,或者类似身份证这样的唯一列= (select 主键列,或者类似身份证这样的唯一列 from (select 主键列,或者类似身份证这样的唯一列,rownum rn from table) where rn=c_rn) c_id:=c_id+1; c_rn=c_rn+1; exit when c_id=10000+1; end loop; end;本回答被提问者采纳