Oracle PL/SQL Interactive Workbook, 2/e

Appropriate for beginning to intermediate courses in Oracle PL/SQL.

Fully updated and expanded for Oracle 9i, this integrated book-and-Web learning solution is designed to help students master Oracle PL/SQL as quickly as possible. Its unique workbook-based pedagogy incorporates hands-on, real-world labs, exercises, and projects, as well as an outstanding Web-based training site containing Test Your Thinking project solutions and detailed explanations; additional self-review exercises with instant feedback and explanations; and an exclusive Virtual Study Lounge where students can interact with each other. The book's coverage includes every fundamental PL/SQL concept, skill, and technique, including PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging—plus powerful new techniques for working with exceptions, cursors, collections, and records.

Table of Contents

Acknowledgments.
About the Authors.
Introduction.
1. Programming Concepts.
2. PL/SQL Concepts.
3. General Programming Language Fundamentals.
4. SQL in PL/SQL.
5. Conditional Control: IF Statements.
6. Conditional Control: Case Statements.
8. Iterative Control.
9. Introduction to Cursors.
10. Exceptions.
11. Exceptions: Advanced Concepts.
12. Procedures.
13. Functions.
14. Packages.
15. Advanced Cursors.
16. Stored Code.
17. Triggers.
18. Collections.
19. Records.
Appendix A. Answers to Self-Review Questions.
Appendix B. PL/SQL Formatting Guide.
Appendix C. Student Database Schema.
Appendix D. Answers to Test Your Thinking Sections.
Appendix E. Oracle 9i SQL New Features.
Index.