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:
- Go to View | Reports:
- Go to All Reports | Data Dictionary Reports | PLSQL:
- Under PLSQL, you find three options. ...