Click No Browse: How to Navigate Objects Without Opening Them

thatjeffsmith SQL Developer 15 Comments

Tell Others About This Story:

Oracle SQL Developer by default automatically opens the object editor when you click on an object in your connection tree or schema browser. For most folks this is very convenient. But if you are selecting objects to drag them to a model or to the worksheet, this can get annoying as the focus of the screen changes when you don’t want it to.

The other scenario this feature might disrupt more than delight is when you want to click around the database in the tree and every time you click on an object, the object editor automatically changes to the selected object.

You can disable this automatic browsing behavior in SQL Developer by modifying this preference:

Tools > Preferences > Database > ObjectViewer > Open Object on Single Click

Disable this if you don’t want an object to open when you click on it

OK, I do realize my description of the problem may have confused the heck out of you just now. So instead of more words, how about a couple of animations of the object-click behavior with the option ON and OFF?

Preference Disabled

Click, no open. Double click, open.

Preference Enabled (Default)

As you click on objects, they are automatically opened

Tell Others About This Story:

Comments 15

    1. thatjeffsmith Post
      Author
  1. hi,

    Is there similar functionality for the reports?
    A tad bit frustrating when you want to click on a report to edit it and SQL Developer attempts to run it.

    Thanks
    N.

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author

      Thanks again. Some things are just too hard to describe with words, so taking 30 seconds to record some screencasts for a GIF seemed like a no-brainer. If you are having problems with anything else, and feel that a video or blog post might help, please let me know!

  2. Are there more settings to configure these behaviors? What seems intuitive to me (at least for tables and views) is for the +/- (on PC) or >/V (on Mac) to expand/collapse the information in the Connections pane *without* changing what’s being displayed in the ‘main’ pane. Clicking a table or view should (in my intuition) open something in the main pane. Data is the tab *I* use most commonly, so I would prefer that be the default (rather than Columns or whichever-tab-was-most-recently-used).
    Is this possible using existing options? Do other people work similarly?

    1. thatjeffsmith Post
      Author

      Expanding the object => Open object. I agree, that’s not the intuitive behavior. There’s no option to control that, but I’d be happy to log an enhancement request for you.

      MRU is controlling the default panel you see when browsing a table or view. That does seem intuitive to me though.

    1. thatjeffsmith Post
      Author

      All of my screenshots are done with @techsmith – either SnagIt or Camtasia Studio. I record the screen, then produce the edited video as a .GIF. Takes only a few minutes once you get used to the editing booth.

        1. thatjeffsmith Post
          Author

Leave a Reply

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