Lab 16.1 Gathering Stored Code Information

Lab Objectives

After this Lab, you will be able to:

Get Stored Code Information from the Data Dictionary

Enforce Purity Level with RESTRICT_REFERENCES Pragma

Overload Modules

Stored programs are stored in compiled form in the database. Information about the stored programs is accessible through various data dictionary views. In Chapter 11 you learned about the two data dictionary views USER_OBJECTS and USER_SOURCE. Additionally, you learned about the USER_TRIGGERS view in Chapter 8. There are a few more data dictionary views that are useful for obtaining information about stored code. In this lab, you will learn how to take advantage of these.