To remove duplicate's using a loop in Oracle:
BEGIN
FOR Lcntr IN 1..560
LOOP
DELETE TABLE WHERE ROWID IN
(
SELECT min(ROWID)
FROM TABLE
GROUP BY COLUMN1, COLUMN2, COLUMN3, ...
HAVING count(1) > 1
);
END LOOP;
END;
And then, COMMIT; or ROLLBACK;
Geen opmerkingen:
Een reactie posten