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

thatjeffsmith SQL Developer 27 Comments

Tell Others About This Story:

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.

Tell Others About This Story:

Comments 27

  1. I’ve been using this tool for years and did not know I could do this. Very frustrating as this is not as obvious as you make it seem. Glad I found your post.

    Feedback:

    1. PIN: Never clicked on it as I never understood why I would want to pin the column tab for a table. PIN should perhaps be up on tab itself or listed in context when right clicking tab. Like “Pin Tab”.

    2. Document Tab Group: Not obvious either as when I tried this, I just got multiple windows but table was still replaced with different one when clicking on different table.

    3. Settings: Looked all over settings for “Document” or “Document Tab” since right click on tab did not indicate it was an Object Viewer Tab but indicates it is a “Document Tab” with choice to open new “Document Tab Group”. Perhaps it should be “New Object Viewer Group” or at least consistent naming between view and preferences.

    Thanks, Dave

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
  2. How can Oracle Developer suck so much? Seriously guys.
    Try to the least to make it usable without getting an aneurysm from the frustration

    1. thatjeffsmith Post
      Author
      1. Maybe people register those addresses when they are forced to put up with this crap. How is there no easy way to install oracle sql client for the command line, even in debian base o.s.?

        1. thatjeffsmith Post
          Author

          Why did we have to get into insults before you even told me what your issue is? How am I expected to react here?

          Instant Client is easy. Download, unzip. Update $PATH. Go.

          I don’t mind you telling me that you’re upset, I understand that and want to help.

          You can get SQL Developer to run on Debian too, google it, lots of folks have written how to do it.

          1. You are actually too nice to idiots spewing out crap on the internet (me). I tried already but there is no direct installation (via e.g. apt-get) and it baffled me. That and trying for 1h to understand what the errors oracle developer gives out can make people upset and have them become assholes.
            Sorry for that.

          2. thatjeffsmith Post
            Author
  3. Thanks a lot for this!
    I must say that your blog helped me a lot.
    To be honest – sometimes I found the SQL Developer not so “nice” to use, but you showed very simple settings (that I overlooked) and that really helps and makes the work better.
    Thank you again for sharing the information.

  4. This is a feature that I use the most.

    When I work in sqldeveloper, more often than not, I will have something side by side. Usually, what I do is I just click and drag the tab header to either the top or sides depending if you want a horizontal (top/bottom) or vertical (left/right) split. Just drag until you see red placeholder lines.

    Also, if you have a tab that shows a table object (for example, the employee table), in the data view, you can also split the view horizontally and vertically WITHIN the tab. Look for the splitter at the top and and right hand sides of the scroll bars and drag them. The advantage of this is that if you are looking for multiple employees or whatever, you can have multiple views each with it’s own filter. To get rid of them, just drag it back to the top or right.

    1. thatjeffsmith Post
      Author
  5. I also noticed that after you have pinned tables, you can drag and drop the table editor tabs to view multiple tables at the same time.

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *