Books & Videos

Table of Contents

  1. Programming in PL/SQL

    1. Chapter 1 Introduction to PL/SQL

      1. What Is PL/SQL?
      2. The Origins of PL/SQL
      3. So This Is PL/SQL
      4. About PL/SQL Versions
      5. Resources for PL/SQL Developers
      6. Some Words of Advice
    2. Chapter 2 Creating and Running PL/SQL Code

      1. Navigating the Database
      2. Creating and Editing Source Code
      3. SQL*Plus
      4. Performing Essential PL/SQL Tasks
      5. Editing Environments for PL/SQL
      6. Calling PL/SQL from Other Languages
    3. Chapter 3 Language Fundamentals

      1. PL/SQL Block Structure
      2. The PL/SQL Character Set
      3. Identifiers
      4. Literals
      5. The Semicolon Delimiter
      6. Comments
      7. The PRAGMA Keyword
      8. Labels
  2. PL/SQL Program Structure

    1. Chapter 4 Conditional and Sequential Control

      1. IF Statements
      2. CASE Statements and Expressions
      3. The GOTO Statement
      4. The NULL Statement
    2. Chapter 5 Iterative Processing with Loops

      1. Loop Basics
      2. The Simple Loop
      3. The WHILE Loop
      4. The Numeric FOR Loop
      5. The Cursor FOR Loop
      6. Loop Labels
      7. The CONTINUE Statement
      8. Tips for Iterative Processing
    3. Chapter 6 Exception Handlers

      1. Exception-Handling Concepts and Terminology
      2. Defining Exceptions
      3. Raising Exceptions
      4. Handling Exceptions
      5. Building an Effective Error Management Architecture
      6. Making the Most of PL/SQL Error Management
  3. PL/SQL Program Data

    1. Chapter 7 Working with Program Data

      1. Naming Your Program Data
      2. Overview of PL/SQL Datatypes
      3. Declaring Program Data
      4. Programmer-Defined Subtypes
      5. Conversion Between Datatypes
    2. Chapter 8 Strings

      1. String Datatypes
      2. Working with Strings
      3. String Function Quick Reference
    3. Chapter 9 Numbers

      1. Numeric Datatypes
      2. Number Conversions
      3. Numeric Operators
      4. Numeric Functions
    4. Chapter 10 Dates and Timestamps

      1. Datetime Datatypes
      2. Getting the Current Date and Time
      3. Interval Datatypes
      4. Datetime Conversions
      5. Date and Timestamp Literals
      6. Interval Conversions
      7. Interval Literals
      8. CAST and EXTRACT
      9. Datetime Arithmetic
      10. Date/Time Function Quick Reference
    5. Chapter 11 Records

      1. Records in PL/SQL
    6. Chapter 12 Collections

      1. Collections Overview
      2. Collection Methods (Built-ins)
      3. Working with Collections
      4. Nested Table Multiset Operations
      5. Maintaining Schema-Level Collections
    7. Chapter 13 Miscellaneous Datatypes

      1. The BOOLEAN Datatype
      2. The RAW Datatype
      3. The UROWID and ROWID Datatypes
      4. The LOB Datatypes
      5. Working with LOBs
      6. Predefined Object Types
  4. SQL in PL/SQL

    1. Chapter 14 DML and Transaction Management

      1. DML in PL/SQL
      2. Transaction Management
      3. Autonomous Transactions
    2. Chapter 15 Data Retrieval

      1. Cursor Basics
      2. Working with Implicit Cursors
      3. Working with Explicit Cursors
      4. SELECT...FOR UPDATE
      5. Cursor Variables and REF CURSORs
      6. Cursor Expressions
    3. Chapter 16 Dynamic SQL and Dynamic PL/SQL

      1. NDS Statements
      2. Binding Variables
      3. Working with Objects and Collections
      4. Dynamic PL/SQL
      5. Recommendations for NDS
      6. When to Use DBMS_SQL
      7. Oracle Database 11g New Features
  5. PL/SQL Application Construction

    1. Chapter 17 Procedures, Functions, and Parameters

      1. Modular Code
      2. Procedures
      3. Functions
      4. Parameters
      5. Local or Nested Modules
      6. Module Overloading
      7. Forward Declarations
      8. Advanced Topics
      9. Go Forth and Modularize!
    2. Chapter 18 Packages

      1. Why Packages?
      2. Rules for Building Packages
      3. Rules for Calling Packaged Elements
      4. Working with Package Data
      5. When to Use Packages
      6. Packages and Object Types
    3. Chapter 19 Triggers

      1. DML Triggers
      2. DDL Triggers
      3. Database Event Triggers
      4. INSTEAD OF Triggers
      5. AFTER SUSPEND Triggers
      6. Maintaining Triggers
    4. Chapter 20 Managing PL/SQL Code

      1. Managing Code in the Database
      2. Managing Dependencies and Recompiling Code
      3. Compile-Time Warnings
      4. Testing PL/SQL Programs
      5. Tracing PL/SQL Execution
      6. Debugging PL/SQL Programs
      7. Protecting Stored Code
      8. Introduction to Edition-Based Redefinition (Oracle Database 11g Release 2)
    5. Chapter 21 Optimizing PL/SQL Performance

      1. Tools to Assist in Optimization
      2. The Optimizing Compiler
      3. Data Caching Techniques
      4. Bulk Processing for Multirow SQL
      5. Improving Performance With Pipelined Table Functions
      6. Specialized Optimization Techniques
      7. Stepping Back for the Big Picture on Performance
    6. Chapter 22 I/O and PL/SQL

      1. Displaying Information
      2. Reading and Writing Files
      3. Sending Email
      4. Working with Web-Based Data (HTTP)
      5. Other Types of I/O Available in PL/SQL
  6. Advanced PL/SQL Topics

    1. Chapter 23 Application Security and PL/SQL

      1. Security Overview
      2. Encryption
      3. Row-Level Security
      4. Application Contexts
      5. Fine-Grained Auditing
    2. Chapter 24 PL/SQL Architecture

      1. Who (or What) is DIANA?
      2. How Does Oracle Execute PL/SQL Code?
      3. The Default Packages of PL/SQL
      4. Execution Authority Models
      5. Conditional Compilation
      6. PL/SQL and Database Instance Memory
      7. Native Compilation
      8. What You Need to Know
    3. Chapter 25 Globalization and Localization in PL/SQL

      1. Overview and Terminology
      2. Unicode Primer
      3. Character Semantics
      4. String Sort Order
      5. Multilingual Information Retrieval
      6. Date/Time
      7. Currency Conversion
      8. Globalization Development Kit for PL/SQL
    4. Chapter 26 Object-Oriented Aspects of PL/SQL

      1. Introduction to Oracle’s Object Features
      2. Object Types by Example
      3. Object Views
      4. Maintaining Object Types and Object Views
      5. Concluding Thoughts from a (Mostly) Relational Developer
    5. Chapter 27 Calling Java from PL/SQL

      1. Oracle and Java
      2. Getting Ready to Use Java in Oracle
      3. A Simple Demonstration
      4. Using loadjava
      5. Using dropjava
      6. Managing Java in the Database
      7. Using DBMS_JAVA
      8. Publishing and Using Java in PL/SQL
    6. Chapter 28 External Procedures

      1. Introduction to External Procedures
      2. The Oracle Net Configuration
      3. Setting Up Multithreaded Mode
      4. Creating an Oracle Library
      5. Writing the Call Specification
      6. Raising an Exception from the Called C Program
      7. Nondefault Agents
      8. Maintaining External Procedures
  1. Appendix Regular Expression Metacharacters and Function Parameters

    1. Metacharacters

    2. Functions and Parameters

  2. Appendix Number Format Models

  3. Appendix Date Format Models

  4. Colophon