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.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. 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

    • thatjeffsmith

      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

    • thatjeffsmith

      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