ORACLE: delete duplicate rows

Oracle SQL to remove duplicate rows from a table:

DELETE FROM
   TABLE_NAME A
WHERE
  A.COLUMN_NAME >
   ANY (
     SELECT
        B.COLUMN_NAME
     FROM
        TABLE_NAME B
     WHERE
        A.COLUMN_NAME = B.COLUMN_NAME

   );