Oracle SQL Developer multiple table views Oracle SQL Developer multiple table views oracle oracle

Oracle SQL Developer multiple table views


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


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.


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.