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:
Go to View | Reports:
Go to All Reports | Data Dictionary Reports | PLSQL:
Under PLSQL, you find three options. These options are analogous to the dictionary views which we queried in the preceding section.
The Program Unit Arguments option queries the
USER_ARGUMENTSdictionary view. The Search Source Code and Unit Line Counts options query theUSER_SOURCEview.When you click on any of the options for the first time, the following dialog box pops up...