Generating a Data Dictionary Report and Diagram for a SubView

thatjeffsmith SQL Developer 5 Comments

Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on the main File menu. First, we don’t want the main diagram in the report, that’ll …

PL/Scope in Oracle Database 12c Release 2 and Oracle SQL Developer

thatjeffsmith SQL Developer 7 Comments

PL/Scope is one of my favorite features. It answers SO many questions. Where am I declaring this, where am I calling that, when am I referencing something? And, I can get this information automatically, without hitting the big, fat SOURCE data dictionary views. I’ve talked about this previously… …BUT, PL/SCope didn’t help me with tracking the SQL I used in …

Viewing Automatic SQL Tuning Advisor Tasks in Oracle SQL Developer

thatjeffsmith SQL Developer 1 Comment

I got a question from our internal mailing list… I would like to know how I can view historical SQL tuning recommendations in SQL Developer 4. I don’t want to run the sql worksheet manually but view the automatic recommendations as the query has been running already for several days now. I’m guessing their query hasn’t been running for several …

2 Reports You Might Enjoy in Oracle SQL Developer

thatjeffsmith SQL Developer 5 Comments

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer. Today I’m going to share 2 reports that I frequently forget about, that you may enjoy. Finding Unindexed Foreign Keys We all know this should not happen. We all know it eventually happens. Here’s a report to help you quickly find these …

Advice on Finding Your Way Around a New Oracle Database

thatjeffsmith SQL Developer 2 Comments

Received this query from a customer this morning… For your information, I’m average in SQL. What I would really like to know is if you can give me some tips regarding the use of Oracle SQL Developer in relation to a completely new database. So, are there functions/tools in Oracle SQL Developer which can help me better understand a new …