It’s a relational database, so it’s only a matter of time before you stumble across an object that’s dependent on another object, right?

If you are looking at a table in the browser, be sure to check out the ‘Dependencies’ page. This page displays the database objects that will be upset if the selected table were to ‘go away.’ You’re probably familiar with these related objects, but if not, then there’s a quick ‘trick’ to investigate further.

Let’s take a look at SH.SALES as an example:

Auto-navigate to the selected object in the grid

This takes me to SH.CAL_MONTH_SALES_MV, a materialized view.

When I’m done poking around, I might want to go back to my SALES table.

The ‘Back’ and ‘Forward’ buttons on the main toolbar serve as my Most-Recently-Used tree navigation buttons.

If you can work a web browser, you can mostly work SQL Developer, mostly
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.

Write A Comment