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.正确的语句应该怎么写