O'Reilly logo

Oracle SQL Developer by Ajith Narayanan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. The Power of SQL Reports

In addition to browsing objects and writing your own ad hoc queries against the database, Oracle SQL Developer has a separate Reports navigator with a set of predefined SQL queries known as reports. The main focus is the set of predefined data dictionary reports that range from providing basic details about your database to database administration, security, and quality assurance. Having these predefined reports means that you can quickly run a variety of SQL queries to analyze and assess the health and status of your database, saving you from needing to write the queries yourself.

The Reports navigator provides shipped reports to review the results of any non-Oracle database migrations that have been run, the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required