ThatJeffSmith

30 SQL Developer Tips in 30 Days, Day 10: Compare Stuff Side By Side

Tell Others About This Story:

We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B.

So let’s look at a few scenarios.

Execution Plans or Autotrace Runs

Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila.

Partitioning makes all the difference :)

Partitioning makes all the difference 🙂

Looking at Objects, Side By Side

So what’s the difference between those two hockey stat tables?

Open a table. Pin it. Open the second table. Pin it. Right click on the 2nd table editor tab, and say ‘New Document Tab Group.’

Two table editors, side-by-side. One has some nice partitions, the other has none.

Two table editors, side-by-side. One has some nice partitions, the other has none.

Show me table definitions, or any OTHER object.

Tools > Database Diff. Pick A, Pick B, select the object or objects you want compared.

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

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

But I want to compare programs or queries!

Open program or query 1. File > Compare with. Bingo.

The code, side by side, again with difference highlighted.

The code, side by side, again with difference highlighted.

Need more help or detailed instructions?

I have detailed posts on how to do all of these compares in SQL Developer. Just use the search panel on your right to find what you’re looking for.

Bonus: Comparing Data Models!

Yeah, we can do that too.

I've changed the column from a CLOB to a VARCHAR(4000)

I’ve changed the column from a CLOB to a VARCHAR(4000)

You can even compare the diagrams – you’ll see how the coordinate system mapping points are different…just in case that’s really important to you.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Similar Posts by Content Area: , , , , , ,