Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

30 SQL Developer Tips in 30 Days, Day 11: Tree Trimming

1 Min Read

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.

Related Posts

5 Comments

  1. renu Reply

    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 Post Author

      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 Post Author

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

  3. Joel B. Reply

    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