title: Removing duplicate rows from table in Oracle
body: <p>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.</p>
  
  <p>How can I delete all duplicate rows and leave only one of them?</p>