There’s a nasty rumor going around that you can’t compare database objects and/or code in Oracle SQL Developer. So let’s put that to bed right now. First, here’s how to compare:

• PL/SQL to PL/SQL or a SQL statement to another SQL statement

So now that that’s settled, why don’t we take a look at how to compare a single table, to another table – whether it’s in the same database or a different database.

Database Diff

There’s no additional licensing requirement here. If you have SQL Developer, you can use this feature.

if you’re going to compare 1 table to another, make sure you ONLY have ‘tables’ checked

And then, use this dialog to select your table(s):

Move over the object(s) you want to compare over to the right hand side.

And now we can move onto the results.

The differences, side-by-side, and the script to make B look like A

Common lines with differences are highlighted in blue, new lines are highlighted in red.

So that’s why they are different, but here’s the script to synch up the differences:

Read the script, TEST the script, apply the script.

And that’s it. Well, that’s mostly it. If you have questions about how to compare a database object in a schema you don’t have the login information for, read this post next.