donderdag 25 april 2013

Oracle: Remove duplicate's with a loop

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