You are previewing Oracle® PL/SQL® Interactive Workbook, Second Edition.
O'Reilly logo
Oracle® PL/SQL® Interactive Workbook, Second Edition

Book Description

  • Build Oracle PL/SQL applications—now.

  • Fully updated for Oracle 9i

  • No Oracle PL/SQL experience necessary.

  • Real-life labs and "Test Your Thinking" Q&As

Start developing applications with Oracle PL/SQL—fast. This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, exercises, projects, and a complete Web-based training site. Completely updated for Oracle 9i, it covers all the fundamentals—and a whole lot more. Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging—plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates.

Totally integrated with a FREE, state-of-the-art Oracle 9i learning Web site.

Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:

  • "Test Your Thinking" project solutions and detailed explanations

  • Additional self-review exercises with instant feedback and explanations

  • An exclusive Virtual Study Lounge where you can interact with other students.

Just the facts. No endless, boring discussions here. You'll learn hands on through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject. It's an integrated learning system that's proven to work.

Dozens of exercises cover the real-world tasks that matter most.

Hundreds of self-review questions and answers make sure you understand.

Table of Contents

  1. Copyright
  2. The Prentice Hall PTR Oracle Series
  3. Acknowledgments
  4. About the Authors
  5. Introduction
  6. About Prentice Hall Professional Technical Reference
  7. Programming Concepts
    1. Lab 1.1 The Nature of a Computer Program and Programming Languages
    2. Lab 2.1 Good Programming Practices
    3. Chapter 1 Test Your Thinking
  8. PL/SQL Concepts
    1. Lab 2.1 PL/SQL In Client-Server Architecture
    2. Lab 2.2 PL/SQL in SQL*Plus
    3. Chapter 2 Test Your Thinking
  9. General Programming Language Fundamentals
    1. Lab 3.1 PL/SQL Programming Fundamentals
    2. Chapter 3 Test Your Thinking
  10. SQL in PL/SQL
    1. Lab 4.1 Making Use of DML in PL/SQL
    2. Lab 4.2 Making Use of SAVEPOINT
    3. Chapter 4 Test Your Thinking
  11. Conditional Control: IF Statements
    1. Lab 5.1 IF Statements
    2. Lab 5.2 ELSIF Statements
    3. Lab 5.3 Nested IF Statements
    4. Chapter 5 Test Your Thinking
  12. Conditional Control: Case Statements
    1. Lab 6.1 CASE Statements
    2. Lab 6.2 CASE Expressions
    3. Lab 6.3 NULLIF and COALESCE Functions
    4. Chapter 6 Test Your Thinking
  13. Error Handling and Built-In Exceptions
    1. Lab 7.1 Handling Errors
    2. Lab 7.2 Built-In Exceptions
    3. Chapter 7 Test Your Thinking
  14. Iterative Control
    1. Lab 8.1 Simple Loops
    2. LAB 8.2 WHILE Loops
    3. Lab 8.3 Numeric for Loops
    4. Lab 8.4 Nested Loops
    5. Chapter 8 Test Your Thinking
  15. Introduction to Cursors
    1. Lab 9.1 Cursor Manipulation
    2. Lab 9.2 Using Cursor for Loops and Nesting Cursors
    3. Chapter 9 Test Your Thinking
  16. Exceptions
    1. Lab 10.1 Exception Scope
    2. Lab 10.2 User-Defined Exceptions
    3. Lab 10.3 Exception Propagation
    4. Chapter 10 Test Your Thinking
  17. Exceptions: Advanced Concepts
    1. Lab 11.1 RAISE_APPLICATION_ERROR
    2. Lab 11.2 EXCEPTION_INIT Pragma
    3. Lab 11.3 SQLCODE and SQLERRM
    4. Chapter 11 Test Your Thinking
  18. Procedures
    1. PL/SQL Stored Code
    2. Lab 12.1 Creating Procedures
    3. Lab 12.2 Passing Parameters In and Out of Procedures
    4. Chapter 12 Test Your Thinking
  19. Functions
    1. Lab 13.1 Creating and Using Functions
    2. Chapter 13 Test Your Thinking
  20. Packages
    1. Lab 14.1 The Benefits of Utilizing Packages
    2. Chapter 14 Test Your Thinking
  21. Advanced Cursors
    1. Lab 15.1 Using Parameters with Cursors and for Update Cursors
    2. Lab 15.2 Cursor Variables
  22. Stored Code
    1. Lab 16.1 Gathering Stored Code Information
    2. Chapter 16 Test Your Thinking
  23. Triggers
    1. Lab 17.1 What Triggers Are
    2. Lab 17.2 Types of Triggers
    3. Lab 17.3 Mutating Table Issues
    4. Chapter 17 Test Your Thinking
  24. Collections
    1. Lab 18.1 PL/SQL Tables
    2. Lab 18.2 Varrays
    3. Lab 18.3 Multilevel Collections
    4. Chapter 18 Test Your Thinking
  25. Records
    1. Lab 19.1 Records
    2. Lab 19.2 Nested Records
    3. Lab 19.3 Collections of Records
    4. Chapter 19 Test Your Thinking
  26. Answers to Self-Review Questions
    1. Chapter 1 Programming Concepts
    2. Chapter 2 PL/SQL Concepts
    3. Chapter 3 General Programming Language Fundamentals
    4. Chapter 4 SQL in PL/SQL
    5. Chapter 5 Conditional Control: IF Statements
    6. Chapter 6 Conditional Control: CASE Statements
    7. Chapter 7 Error Handling and Built-In Exceptions
    8. Chapter 8 Iterative Control
    9. Chapter 9 Introduction to Cursors
    10. Chapter 10 Exceptions
    11. Chapter 11 Exceptions: Advanced Concepts
    12. Chapter 12 Procedures
    13. Chapter 13 Functions
    14. Chapter 14 Packages
    15. Chapter 15 Advanced Cursors
    16. Chapter 16 Stored Code
    17. Chapter 17 Triggers
    18. Chapter 18 Collections
    19. Chapter 19 Records
  27. PL/SQL Formatting Guide
    1. PL/SQL Code Naming Conventions and Formatting Guidelines
    2. Other Suggestions
  28. Student Database Schema
    1. Table and Column Descriptions
  29. Answers to Test Your Thinking Sections
    1. Chapter 1 Programming Concepts
    2. Chapter 2 PL/SQL Concepts
    3. Chapter 3 General Programming Language Fundamentals
    4. Chapter 4 SQL in PLSQL
    5. Chapter 5 Conditional Control: IF Statements
    6. Chapter 6 Conditional Control: CASE Statements
    7. Chapter 7 Error Handling and Built-In Exceptions
    8. Chapter 8 Iterative Control
    9. Chapter 9 Introduction to Cursors
    10. Chapter 10 Exceptions
    11. Chapter 11 Exceptions: Advanced Concepts
    12. Chapter 12 Procedures
    13. Chapter 13 Functions
    14. Chapter 14 Packages
    15. Chapter 15 Stored Code
    16. Chapter 17 Triggers
    17. Chapter 18 Collections
    18. Chapter 19 Records
  30. Oracle 9i SQL New Features
    1. SQL Standards
    2. JOINs
    3. Scalar Subquery