O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

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

Chapter 16 Stored Code

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.
A4:
Questions Answers Comments
4) C 
A5:
Questions Answers Comments
5) B 

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