selecting duplicates

[hameja]

how can I select duplicate records in a table that is not indexed

 

[LKBrwnDBA]

In sqlplus execute the ?/rdbms/admin/utlexcpt.sql script


Create an Index on the columns that make the KEY:

CREATE UNIQUE INDEX ON MyTABLE(COL1, COL2...)
EXCEPTIONS IN EXCEPTIONS;

All duplicate rows will be recorded in the EXCEPTIONS table.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[sem]

In general it does not matter whether your table is indexed or not

select field1, ..., fieldN
from table
group by field1, ..., fieldN
having count(*)>1

You may also find dozen of similar threads with the same question and much wider set of advises, just use search.

Regards, Dima

http://seminihin.narod.ru