Re: Remove duplicate data in Oracle DB

In article <38A8FEA1.35D33056_at_email.sps.mot.com>, Noira Hadi <r42317_at_email.sps.mot.com> wrote:
> I have tables in Oracle database which I could not enforce primary
> key
> due to unavoidable situation. Because of this, I might see
> duplications
> of data row.
> I want to know if it is possible for me to remove the duplicate
> row(s)?
> Appreciate any reply, reference or any tool that I could use to
> overcome
> this situation.
> Thanks in advance.
> Best Regards,
> hadi

Delete from mytable
where rowid not in
(select min(rowid) from mytable
group by keycolumn1,keycolumn2...keycolumnN) /

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!