Toad - Tips N Tricks - Find duplicate data

I am sure you have come across a situation where you needed to find duplicate records in a table and you whipped out your DISTINCT SQL queries.

Toad makes it a lot more easier using it's Data Duplicates tool.

Found under the Database->Compare->Data Duplicates menu, it allows you to specify the columns used in the search for duplicates and then shows you a summary as well as a separate grid where you can delete or modify the records.

The above image shows the interface for the Data Duplicates tool (The 3 tabs that allow you to specify duplicate criteria and then check and fix the duplicate records)