DECLARE
V_COUNT NUMBER;
BEGIN
DELETE FROM EMPLOYEES
WHERE ROWID IN (SELECT ROWID
FROM (SELECT ROWID,
ROW_NUMBER ()
OVER (PARTITION BY EMPLOYEE_ID
ORDER BY 1)ROW_NO
FROM EMPLOYEES)
WHERE ROW_NO > 1);
V_COUNT := SQL%ROWCOUNT;
DBMS_OUTPUT.PUT_LINE(V_COUNT);
END;
No comments:
Post a Comment