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:
- Use the Pins
- Change the Preferences
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.
Now if I open another table, the pinned table editor will remain.
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.
Optimizing 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.
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.
While you’re on this page, make sure you uncheck ‘Open Object on Single Click’ – I find for experienced users this creates more hassle versus making things easier.