Oracle SQL Developer multiple table views

Solution 1:

SQL Developer can start a new tab every time you select a database object to view; but, you will have to close the tab manually.

Set this in: Tools->Preferences->Database->ObjectViewer->Automatically Freeze Object Viewer Windows

Solution 2:

You can pin a tab by clicking the button below :

Tab pin button

No need to configure anything, plus sometimes you don't want to have a tab automatically pinned.

Solution 3:

Jeff Smith posted a nice write up on how to do this in SQL Developer.

There are multiple ways to do it.

  • Freeze content (ctrl-shift-P)
  • New Document Tab Group (will allow viewing tables simultaneously)
  • Change the preferences (If this is desired default behavior)

The post can be found here.