You are previewing Beginning PL/SQL: From Novice to Professional.
O'Reilly logo
Beginning PL/SQL: From Novice to Professional

Book Description

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time with obscure and obsolete features.

Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

  • Discover the 20% of PL/SQL that gives you 80% of the bang! Key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.

  • Learn how to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well.

  • Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents
  4. Foreword
  5. About the Author
  6. Acknowledgments
  7. Introduction (The Big Picture)
    1. What's a Stored Procedure?
    2. Why Use Stored Procedures?
    3. What's This Book About?
  8. CHAPTER 1: Genesis
    1. Tables
    2. Indexes
    3. Constraints
    4. Triggers
    6. Insert
    7. Update
    8. Delete
    9. Select
    10. Our Working Example
    11. Summary
  9. CHAPTER 2: PL/SQL Is Square, Man!
    1. Anonymous Blocks
    2. Exceptions
    3. Functions
    4. Procedures
    5. Nested Blocks
    6. Packages
    7. Summary
  10. CHAPTER 3: Now Where Did I Put That?
    1. PL/SQL Data Types
    2. Variables
    3. Scope
    4. Types
    5. Parameters
    6. Summary
  11. CHAPTER 4: Whoa! One Statement at a Time, Please!
    1. Inserts
    2. Updates
    3. Deletes
    4. Selects
    5. Summary
  12. CHAPTER 5: Next Please, One Row at a Time!
    1. Cursors
    2. Bulk Collect
    3. For All
    4. Summary
  13. CHAPTER 6: Just Like It Is in the Real World!
    1. Information Modeling
    2. Object Orientation
    3. Service Orientation
    4. A Roadmap to Reality
    5. A Change in Order
    6. Object Types
    7. Object Views
    8. Object Tables
    9. Impedance Mismatch My Foot!
    10. Summary
  14. CHAPTER 7: So Just What's Happening Here?
    1. Prevention
    2. Preparation
    3. After the Fact
    4. As It Happens
    5. One Step at a Time
    6. Profiling
    7. Hey, Don't Forget SQL!
    8. Summary
  15. CHAPTER 8: Test, Test, Test, and Test Again
    1. SQL Test Patterns
    2. PL/SQL Test Patterns
    3. A Testing Tool
    4. Testing
    5. Automating Testing
    6. Summary
  16. CHAPTER 9: What Does This Thing Do Anyway?
    1. Indestructible Documentation
    2. Documentation on Demand
    3. Distributable Documentation
    4. Documentation Distribution
    5. Summary
  17. CHAPTER 10: Fairy Tales
    1. Polymorphic Commands
    2. The Unhappy SQL Programmer
    3. The Black Box
    4. Divide and Conquer
    5. Summary
  18. APPENDIX: How to Download, Install, and Use Oracle
    1. How to Download Oracle Database Software
    2. How to Install Oracle Database Software
    3. How to Use SQL*Plus
  19. Index