Oracle PL/SQL Programming, 6th Edition

Considered throughout the Oracle technology community to be the best Oracle PL/SQL Programming, 6th Edition book available, this guide is the definitive reference on Oracle’s powerful procedural language. Like its predecessors, this sixth edition covers language fundamentals, advanced coding techniques, and best practices for using PL/SQL.

Thoroughly updated for Oracle Database 12c Release 1, this edition is packed with syntax, advice, and a great deal of new information. Extensive code samples, ranging from easy-to-follow examples to reusable packaged utilities, are available in the book and on the companion website.

• Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
• Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
• Optimize PL/SQL performance with tools and techniques such as PL/Scope and the PL/SQL hierarchical profiler
• Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
• Build modular PL/SQL applications using procedures, functions, triggers, and packages
• Use the updated online resources available on the book’s companion website to accelerate development of your own code

Table of Contents

Part I: Programming in PL/SQL
Chapter 1. Introduction to PL/SQL
Chapter 2. Creating and Running PL/SQL Code
Chapter 3. Language Fundamentals

Part II: PL/SQL Program Structure
Chapter 4. Conditional and Sequential Control
Chapter 5. Iterative Processing with Loops
Chapter 6. Exception Handlers

Part III: PL/SQL Program Data
Chapter 7. Working with Program Data
Chapter 8. Strings
Chapter 9. Numbers
Chapter 10. Dates and Timestamps
Chapter 11. Records
Chapter 12. Collections
Chapter 13. Miscellaneous Datatypes

Part IV: SQL in PL/SQL
Chapter 14. DML and Transaction Management
Chapter 15. Data Retrieval
Chapter 16. Dynamic SQL and Dynamic PL/SQL

Part V: PL/SQL Application Construction
Chapter 17. Procedures, Functions, and Parameters
Chapter 18. Packages
Chapter 19. Triggers
Chapter 20. Managing PL/SQL Code
Chapter 21. Optimizing PL/SQL Performance
Chapter 22. I/O and PL/SQL

Part VI: Advanced PL/SQL Topics
Chapter 23. Application Security and PL/SQL
Chapter 24. PL/SQL Architecture
Chapter 25. Globalization and Localization in PL/SQL
Chapter 26. Object-Oriented Aspects of PL/SQL
Chapter 27. Calling Java from PL/SQL
Chapter 28. External Procedures

Appendix A. Regular Expression Metacharacters and Function Parameters
Appendix B. Number Format Models
Appendix C. Date Format Models