Using SQL Developer to find coding information

The object metadata information retrieved from the dictionary views is a conventional way to track code information. But these days, the IDE have been made self-sufficient to generate some vital predefined reports. The metadata information demonstrated in the last section using dictionary views can also be generated from SQL Developer. SQL Developer is a free UI based interactive IDE tool which boards multiple database utilities.

Here, we will demonstrate the tracking of code through SQL Developer:

  1. Go to View | Reports:
    Using SQL Developer to find coding information
  2. Go to All Reports | Data Dictionary Reports | PLSQL:
    • Under PLSQL, you find three options. ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with O’Reilly online learning.

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