Monday, November 17, 2008

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.

image

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 3 tabs that allow you to check and fix duplicate 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)

No comments: