The data dictionary keeps track of dependencies, e.g. this VIEW won’t work without THESE tables, synonyms, packages, etc. And you can ‘see’ these in a SQL Developer Object Viewer, like so:

What objects are tracked via the _DEPENDENCIES views.

So that’s nice, but maybe you’d like a picture?

This is a Java FX visual rendering of those same dependencies.

This isn’t included with the base product, rather it’s a freely available Extension we published on GitHub. We provide it as an example of how Java developers can extend the functionality of SQL Developer.

But I’m not a Java developer!

No worries, neither am I! Brian (the actual developer) put together his own GitHub repo to make it easy to pull down this extension via our Check for Updates feature in the product. You only need to clone/download the Zip, and then point to it.

Once you have that on your machine, have our Check for Updates feature point to the ZIp in question, accept the license, restart SQL Developer, and start using the viewer!

Help > Check for Updates > Import from Local File(s)

Once SQL Developer has restarted, you will find a new context menu on your schema objects –

You only have to do this once, then the Dependencies Viewer page will be available going forward.

Now as you open objects, you’ll see this automatically –

You can zoom, move stuff around, open the objects, or save the image as a SVG.

Right-click to get the Buttons …

Ta-da!

Disclaimers

This isn’t a supported feature. But if you want to use it, have at it! You can report ‘issues’ or suggest improvements directly on the GitHub project.

We have other examples, some are just simple XML extensions (no code to write!), others are more complicated like this one.

I’ve talked about these before, namely the MULTI-SELECT-DROP objects context menu you can add if you’re feeling brave and adventurous.

I have 6 tables selected
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.

3 Comments

  1. Hi Jeff,
    Thank you for you answer.
    I changed the directory and copied the zip file oracle.db.example.sqldeveloper.extension.dependency-18.1.0.zip into it.
    The error is still the same:
    The Example Dependency Viewer update cannot be installed because it has a required license agreement that could not be read
    Thank you for your help.
    Regards,
    Armand

  2. Hello Jeff,
    Thank you for you blog for Dependency feature.
    I tried to install it on my Sql Developer Installation.
    But there is the following message that I don’t know how to resolve:
    The Example Dependency Viewer update cannot be installed because it has a required license agreement that could not be read
    Thank you for your help.
    Armand

Write A Comment