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)
No comments:
Post a Comment