APPENDIX CPL/Scope
New to Oracle 11g, PL/Scope is a compiler-driven tool. It collects and organizes data about user-defined identifiers from PL/SQL source code. Identifiers can be reserved words, predefined identifiers, quoted identifiers, user-defined variables, subroutines, user-defined datatypes, or stored program names. Chapter 3 in Oracle Database 11g PL/SQL Programming covers identifiers in PL/SQL thoroughly.
The PL/Scope data is stored in static data dictionary views that contain declaration, definition, reference, call, and assignment of identifiers. They also provide the location of each usage in the source code.
This appendix covers the following topics:
Configuring PL/Scope data collection
Viewing PL/Scope collected data
You should ...
Get Oracle Database 11g PL/SQL Programming Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
