O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required