Oracle Database 12c PL / SQL Programming

Master Oracle Database 12c PL/SQL Application Development

Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.

• Explore new SQL and PL/SQL features in Oracle Database 12c
• Build control structures, cursors, and loop statements
• Work with collections, varrays, tables, and associative array collections
• Locate and repair errors and employ exception handlers
• Execute black box, white box, and integration tests
• Configure and manage stored packages and libraries
• Handle security with authentication and encryption
• Use LOBs to store text and multimedia content
• Write and implement PL/SQL and Java triggers
• Extend functionality using dynamic SQL statements
• Understand object types, nested tables, and unnesting queries

Table of Contents

PART I Oracle PL/SQL
Chapter 1 Oracle PL/SQL Development Overview
Chapter 2 New Features
Chapter 3 PL/SQL Basics
Chapter 4 Language Fundamentals
Chapter 5 Control Structures
Chapter 6 Collections
Chapter 7 Error Management

PART II PL/SQL Programming
Chapter 8 Functions and Procedures
Chapter 9 Packages
Chapter 10 Large Objects
Chapter 11 Object Types
Chapter 12 Triggers
Chapter 13 Dynamic SQL

PART III Appendixes and Glossary
Appendix A Oracle Database Primer
Appendix B SQL Primer
Appendix C SQL Built-in Functions
Appendix D PL/SQL Built-in Packages and Types
Appendix E Regular Expression Primer
Appendix F Wrapping PL/SQL Code Primer
Appendix G PL/SQL Hierarchical Profiler Primer
Appendix H PL/SQL Reserved Words and Keywords
Appendix I Mastery Check Answers