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 :
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.