删除ORACLE数据库中重复的数据
2008-11-02 18:54 马伟 阅读(361) 评论(0) 编辑 收藏 举报
declare
maxrecords constant int:=599;
i int :=1;
begin
for i in 1..maxrecords loop
delete from sf_para_jlddidu where JILIANGDIAN in
(
select JILIANGDIAN from
sf_para_jlddidu group by JILIANGDIAN having count(*)>1
)
AND ROWNUM=1;
end loop;
dbms_output.put_line(' 成功录入数据! ');
commit;
end;
maxrecords constant int:=599;
i int :=1;
begin
for i in 1..maxrecords loop
delete from sf_para_jlddidu where JILIANGDIAN in
(
select JILIANGDIAN from
sf_para_jlddidu group by JILIANGDIAN having count(*)>1
)
AND ROWNUM=1;
end loop;
dbms_output.put_line(' 成功录入数据! ');
commit;
end;