ThatJeffSmith

How to See Two Tables at the Same Time in Oracle SQL Developer

Another post from the FAQ files:

HOW TO OPEN MULTIPLE TABLES IN SQL DEVELOPER SIMULTANEOUSLY

I’m guessing the user is in a hurry, hence the shouting and lack of punctuation. But that’s OK, I think we’ve all been there.

There’s a couple of different ways to get this end result:

  1. Use the Pins
  2. Change the Preferences

Pinning Objects

At the top of every editor in SQL Developer, you’ll see a push pin button in the toolbar. Toggle that push pin to ‘Freeze Content.’ It doesn’t ‘freeze’ your table in the database, but it does force the table editor to persist even as you open another table editor.

The pin is pushed - the editor is now 'frozen'

The pin is pushed – the editor is now ‘frozen’

Now if I open another table, the pinned table editor will remain.

Table two is open, and table one is still there.

Table two is open, and table one is still there.

But I want to SEE both tables at the same time!
Then we need to pull out another trick – ‘New Document Tab Group.’ Right click on the table editor tab and ask for the new document tab group. Voila.

Tab Groups are shown concurrently in the SQL Developer desktop display

Tab Groups are shown concurrently in the SQL Developer desktop display

Change the Preferences

By default, as you open a database object in SQL Developer, it will cause any previously opened object to close. However, you may want to leave these open until you explicitly close them.

This preference, if enabled, will auto-pin any database object you open.

This preference, if enabled, will auto-pin any database object you open.

I’m not a big fan of this preference, but it’s there if you want it. Just don’t forget to close objects when you’re done working with them.