Appendix D. Answers to Test Your Thinking Sections

Chapter 1 Programming Concepts

Chapter 2 PL/SQL Concepts

Chapter 3 General Programming Language Fundamentals

Chapter 4 SQL in PLSQL

Chapter 5 Conditional Control: IF Statements

Chapter 6 Conditional Control: CASE Statements

Chapter 7 Error Handling and Built-In Exceptions

Chapter 8 Iterative Control

Chapter 9 Introduction to Cursors

Chapter 10 Exceptions

Chapter 11 Exceptions: Advanced Concepts

Chapter 12 Procedures

Chapter 13 Functions

Chapter 14 Packages

Chapter 16 Stored Code

Chapter 17 Triggers

Chapter 18 Collections

Chapter 19 Records

Chapter 20 Native Dynamic SQL