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. SQL*Plus
      2. Performing Essential PL/SQL Tasks
      3. Oracle’s PL/SQL-Based Developer Tools
      4. Calling PL/SQL from Other Languages
      5. And What Else?
    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
      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. Tips for Iterative Processing
    3. Chapter 6 Exception Handlers

      1. How PL/SQL Deals with Errors
      2. Defining Exceptions
      3. Raising Exceptions
      4. Handling Exceptions
  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. The Impact of Character Sets
      2. String Datatypes
      3. String Issues
      4. String Functions
      5. NLS Functions
    3. Chapter 9 Numbers

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

      1. Date and Time Datatypes
      2. Date and Timestamp Conversions
      3. Date/Time Arithmetic
      4. Date/Time Functions
    5. Chapter 11 Records and Collections

      1. Records in PL/SQL
      2. Collections in PL/SQL
      3. Declaring Collection Types and Collections
      4. Where Collections Can Be Used
      5. Collection Built-Ins (Methods)
      6. Working with Collections
      7. Collection Pseudo-Functions
      8. Maintaining Collections
      9. Choosing a Collection Type
    6. Chapter 12 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 13 DML and Transaction Management

      1. DML in PL/SQL
      2. Bulk DML with the FORALL Statement
      3. Transaction Management
      4. Autonomous Transactions
    2. Chapter 14 Data Retrieval

      1. Cursor Basics
      2. Working with Implicit Cursors
      3. Working with Explicit Cursors
      4. BULK COLLECT
      5. SELECT...FOR UPDATE
      6. Cursor Variables
      7. Cursor Expressions (Oracle9i)
    3. Chapter 15 Dynamic SQL and Dynamic PL/SQL

      1. NDS Statements
      2. Multirow Queries with Cursor Variables
      3. Binding Variables
      4. Working with Objects and Collections
      5. Building Applications with NDS
      6. NDS Utility Package
      7. Comparing NDS and DBMS_SQL
  5. PL/SQL Application Construction

    1. Chapter 16 Procedures, Functions,and Parameters

      1. Modular Code
      2. Procedures
      3. Functions
      4. Parameters
      5. Local Modules
      6. Module Overloading
      7. Forward Declarations
      8. Advanced Topics
      9. Go Forth and Modularize!
    2. Chapter 17 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 18 Triggers

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

      1. Managing and Analyzing Code in the Database
      2. Protecting Stored Code
      3. Using Native Compilation
      4. Testing PL/SQL Programs
      5. Debugging PL/SQL Programs
      6. Tuning PL/SQL Programs
      7. Improving Application Performance
  6. Advanced PL/SQL Topics

    1. Chapter 20 PL/SQL’s Runtime Architecture

      1. Looking Under the Hood
      2. Dependency Management
      3. PL/SQL’s Use of Memory in the Oracle Server
      4. The Processing of Server-Side PL/SQL
      5. PL/SQL Code on the Client
      6. Execution Authority Models
      7. Hardware for PL/SQL: Bigger = Better?
      8. What You Need to Know
    2. Chapter 21 Object-Oriented Aspects of PL/SQL

      1. Introduction to Oracle’s Object Features
      2. An Extended Example
      3. Object Views
      4. Maintaining Object Types and Object Views
      5. Pontifications
    3. Chapter 22 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
    4. Chapter 23 External Procedures

      1. Introduction to External Procedures
      2. The Oracle Net Configuration
      3. Creating an Oracle Library
      4. Writing the Call Specification
      5. Raising an Exception from the Called C Program
      6. Nondefault Agents
      7. Maintaining External Procedures
  1. Colophon