Summary
In this chapter, we understood the usage of Oracle supplied packages and dictionary views to find the coding information. We got introduced to a new feature in Oracle 11g, the PL/Scope tool, and learned how to determine the usage of an identifier in the PL/SQL program. At the end of the chapter, we covered the DBMS_METADATA package and demonstrated the extraction of a schema object definition as XML or DDL using the package.
In the next chapter, we will overview the strategies of tracing and profiling in PL/SQL.
