Delete Duplicate Rows Based on a Column

There are so many ways available, but I used oracle analytic .

Use analytic to delete duplicate rows
You can  detect and delete duplicate rows using Oracle analytic functions:

delete from
   <<xxx_accounts>>

where rowid in
 (select rowid from
   (select
     rowid,
     row_number()
    over
     (partition by account_name order by account_name) dup
    from <<xxx_accounts>>
    )
  where dup > 1 )