You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
Discuss This Question: