Many of you are not DBAs or developers. You spend most of your time browsing tables, running queries, and answering questions that help make your business ‘go.’

The SQL Developer Connection Tree shows a whole lot of stuff that you might not ever use.

So turn it off.

Tools – Preferences – Database – Navigation Filter

Tell SQL Developer what database objects you want to see when clicking around the tree.
Tell SQL Developer what database objects you want to see when clicking around the tree.

By the way, this a new feature for version 4.0, so if you don’t see it, it’s time to upgrade.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

5 Comments

  1. Hi Jeff,

    That a lovely article but I cant find the navigation filter in SQL developer Version 3.2.20.09. Is this feature not available for this version.

    Regards,
    Renu

    • Yeah, that feature is new for version 4.0, hence this last bit of the story…

      By the way, this a new feature for version 4.0, so if you don’t see it, it’s time to upgrade.

  2. Salek Talangi Reply

    Hi Jeff,

    I like this one very much. Another case of bothered, but not enough bothered to search for a solution.
    Now I have a nice and tidy list of objects I really use.

    Best regards,
    Salek Talangi

    • Yeah, you only do this once, but it helps you EVERY single time you browse the database going forward. Thanks for the feedback!

  3. Hi

    There is a bug with this functionality when selecting Scheduler : Scheduler doesn’t appear.
    Without navigation filter, Scheduler is visible.

    Thx

Write A Comment