oracle database table with duplicates in, and you want to remove said duplicates then you can use something like this:
DELETE FROM myTable
WHERE ROWID IN (SELECT LEAD(ROWID) OVER(PARTITION BY myColumn ORDER BY NULL) FROM myTable);
Replace myTable with the table name, and myColomn with the column that contains the duplicates.
There are other ways to do this, please feel free to list alternatives in the comments.
Hope this helps.