a way to delete duplicate rows in oracle table You can also detect and delete duplicate rows using Oracle analytic functions:

delete from
customer
where rowid in
(select rowid from
(select
rowid,
row_number()
over
(partition by custnbr order by custnbr) dup
from customer)
where dup > 1);