Oracle Database 11g PL/SQL Programming

0.0

Completely up-to-date for the new database release, this Oracle Press guide explains how to write robust, database-driven PL/SQL applications. Full details on the PL/SQL language, scripting semantics, and syntax are included. Learn how to write powerful programs, interact with Oracle databases, perform complex calculations, and handle error conditions. It also features a real-world example that runs throughout the book to illustrate the programming techniques presented.

0.0

Michael McLaughlin is a professor of Computer Information Technology at BYU-Idaho. Table of Contents Part I: PL/SQL Fundamentals Chapter 1. Oracle PL/SQL Overview Chapter 2. PL/SQL Basics Chapter 3. Language Fundamentals Chapter 4. Control Structures Chapter 5. Error Management Part II: PL/SQL Programming Chapter 6. Functions and Procedures Chapter 7. Collections Chapter 8. Large Objects Chapter 9. Packages Chapter 10. Triggers Part III: PL/SQL Advanced Programming Chapter 11. Dynamic SQL Chapter 12. Intersession Communication Chapter 13. External Procedures Chapter 14. Object Types Chapter 15. Java Libraries Chapter 16. Web Application Development Part IV: Appendixes Appendix A. Oracle Database Administration Primer Appendix B. Oracle Database SQL Primer Appendix C. PHP Primer Appendix D. Oracle Database Java Primer Appendix E. Regular Expression Primer Appendix F. Wrapping PL/SQL Code Primer Appendix G. PL/SQL Hierarchical Profiler Primer Appendix H. PL/Scope Appendix I. PL/SQL Reserved Words and Keywords Appendix J. PL/SQL Built-in Functions Index