Oracle PL/SQL Programming, 6th Edition

02/16/2014 · No Responses

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.

Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.

Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers

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