Supposing a table having a hostname column are peppered with duplicate values in the same field.
To eliminate duplicate and keep only one of a kind….
cursor c1 is
select distinct hostname from <table>;
for record in c1
delete from <table> where hostname = record.hostname
rownum != (select count(*) from <table> where hostname = record.hostname);