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

30 SQL Developer Tips in 30 Days, Day 6: Try the Schema Browser

1 Min Read

I’m at a friend’s house, sans laptop, so today’s post will be short and sweet.

Also, no pictures!

In your connection tree, on an active (connected) connection, right-click and select the Schema Browser.

If you hop around users/schemas frequently in a database, you may enjoy the drop-down control for toggling.

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

11 Comments

  1. Pawel Reply

    Is there a way to autoopen the Schema Browser on startup of SQL Developer? It’s my prefered way to work with my objects, but I start the day with connecting to a database, clicking right on the connection and then hitting Schema Browser, which is quite a bit of a task before my first coffee, escepecially because in that state I’m always tempted by the big red icon in the menu which would delete the connection itself.

    So what I would like to have:
    1. Open Up SQL Developer
    2. OHhh, there’s the Schema Browser for the connection I had open yesterday when I closed SQL Developer

    cheers

  2. Mustafa Nural Reply

    Hi Jeff,

    I’m on Version 4.2.0.17.089. Is there a way to make “Filter Schemas” work like the object filters such as “Filter Tables”? If I’m not missing anything, it only allows filtering by a single predicate unlike others. That is not quite useful unless the schemas of interest all have a common prefix etc.

    • Mustafa Nural

      Exactly. I’m enjoying the user filter in the navigation tree so much that I wish same feature was available in the Schema Browser as well

      It would be nice even if there’s an option to apply the filter in the tree to the Schema Browser.

  3. Julian J. Reply

    Hi Jeff,

    First things first. I love this blog.

    Is there any preference for the schema browser to open a table (procedure,function) with a double click instead of a single click?

    Cheers,

    Julian

    • thatjeffsmith Post Author

      Thanks!

      And yes 🙂

      I ALWAYS disable this preference –
      Tools > Preferences > Database > ObjectViewer > Open Object on Single Click

  5. Connor McDonald Reply

    Hi Jeff,

    quick question on the schema browser. When browsing packages, there does not seem to be a way of browsing the *body* (without choosing to edit it).

    Am I missing something obvious ?

    Cheers,
    Connor

    • thatjeffsmith Post Author

      You’re loading it into the PL/SQL editor – whether you choose to edit it or not after that is up to you. There’s no ‘read only’ panel to show you the code behind a PL/SQL object in SQL Developer.

Write A Comment