Title: Identify how to view and manage procedures.
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Creating and Managing Procedures

Identification should include

- a review of the three classes of tables in the data dictionary:
  - USER tables
  - ALL tables
  - DBA tables

- the USER_OBJECTS that define the type and name of an object
- the USER_SOURCECODE table that contains source code for subprograms
- the ALL_SOURCE table that contains source code for all the subprograms that one has privileges to invoke.