谁能帮忙把这个oracle上的存储过程优化下

Question

create or replace procedure delMoreByQyzch is
lostCount int:=0;
begin
for v in (select * from compare_guoshui ) loop
select count(*)into lostCount from compare_guoshui where qyzch=v.qyzch;
if lostCount !=1 then
delete from compare_guoshui c where c.qyzch=v.qyzch and c.id != v.id;
commit;
end if;
end loop;

end delMoreByQyzch;

Answer 1

你的需求是删除表中重复的数据，你参考下sql的解法：
http://space.itpub.net/519536/viewspace-620064