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:

   

2. 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_ARGUMENTS dictionary view. The Search Source Code and Unit Line Counts options query the USER_SOURCE view.

   • When you click on any of the options for the first time, the following dialog box pops up...