Books & Videos

Table of Contents

  1. Chapter 1 PL/SQL: What, When, and Where

    1. What Is PL/SQL?

    2. Why Use PL/SQL?

    3. What You Need to Get Started with PL/SQL

  2. Chapter 2 Fundamentals

    1. PL/Lingo

    2. Running Your First PL/SQL Program

    3. Introduction to Program Structure

    4. Variables

    5. Common Operators

    6. Conditional Logic

    7. Executing in Circles: Loop Statements

    8. Code Formatting: Requirements and Guidelines

    9. Some Advanced Fundamentals

  3. Chapter 3 Let's Code!

    1. Some Background on the Example

    2. A First Programming Exercise

    3. Retrieving a Book Count with a Function

    4. Make Your Code Resilient

    5. Using PL/SQL Packages to Organize Code

    6. Going to the Next Level

    7. Now What?

  4. Chapter 4 Go Web, Young Man

    1. Introduction to HTML

    2. Using PL/SQL to Create Web Pages

    3. What Else?

  5. Chapter 5 Fetch!

    1. What's the Big Deal?

    2. A Simple-Minded Approach to Retrieving One Row

    3. Retrieving More than One Row Using a Cursor

    4. Presenting Query Results via a Web Page

    5. Building a Web-Based Search Page Using Dynamic SQL

    6. Advanced Data Retrieval Topics

  6. Chapter 6 Keeping House

    1. Organize Your Code

    2. Use Tools to Write Code Effectively

  7. Chapter 7 Security: Keep the Bad Guys Out

    1. Oracle Security Primer

    2. Organizing Accounts to Improve Security

    3. Analyzing the Library System's Requirements

    4. Keeping a Trail of Database Changes

    5. Special Security Topics for PL/SQL Developers

  8. Chapter 8 Communicating with the Outside World

    1. Sending Internet Email from PL/SQL

    2. Using the Mail Sender in the Library System

    3. Receiving Email Inside the Database

    4. Fetching Data from a Remote Web Site

    5. Integration with Other Languages

  9. Chapter 9 Intermediate Topics and Other Diversions

    1. Riding the Software Lifecycle

    2. Lists o' Stuff (Collections) in PL/SQL

    3. Exception-Handling Packages

    4. Transaction Control

    5. The PL/SQL Compiler

    6. Managing Patron and Librarian Privileges

    7. Still More PL/SQL Features

  10. Chapter 10 Afterword: "Making Good" of Database Programming

    1. The Evidence

    2. The Problem

    3. Answering the Objections

    4. What to Do

  1. Glossary

  2. Colophon