Oracle® PL/SQL® Interactive Workbook, Second Edition By Benjamin Rosenzweig, Elena Silvestrova
Table of Contents
Appendix A. Answers to Self-Review Questions
Lab 16.1 Self-Review Answers
A1:
Questions
Answers
Comments
1)
B
The USER_ERRORS view only has details on code that is currently in an invalid state. Once the code becomes valid, it will no longer be present in the USER_ERRORS view.
A2:
Questions
Answers
Comments
2)
A
The DESC command can be used on tables and packages. It will give different results for tables and packages.
A3:
Questions
Answers
Comments
3)
B
Only functions within packages require pragma restrictions used in SQL statements.