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 ...

Get Oracle SQL Developer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.