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:
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.
There’s no additional licensing requirement here. If you have SQL Developer, you can use this feature.
And then, use this dialog to select your table(s):
And now we can move onto the results.
The differences, side-by-side, and the script to make B look like A
So that’s why they are different, but here’s the script to synch up the differences:
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.