I'm testing something in Oracle and populated a table with some sample data, but in the process, I accidentally loaded duplicate records, so now I can't create a primary key using some of the columns.
How can I delete all duplicate rows and leave only one of them?