用PLSQL如何自动删除oracle表中重复的数据

Question

1.想用procedure来创建存储过程，但是提示报错
2.CREATE OR REPLACE PROCEDURE "INS_HIS_DEL" AS
BEGIN

delete from INSPECTION_HISTORY t
where (t.point_key,t.inspection_date) in
(select t.point_key,t.inspection_date from INSPECTION_HISTORY t group by t.point_key,t.inspection_date having count(*) > 1)
and rowid not in (select min(rowid) from INSPECTION_HISTORY t group by t.point_key,t.inspection_date having count(*)>1)

END;

3.正确的语句应该怎么写