TOC

   
  
• Table of Contents
Oracle® PL/SQL® Interactive Workbook, Second Edition
By Benjamin Rosenzweig, Elena Silvestrova
 
Publisher: Prentice Hall PTR
Pub Date: October 29, 2002
ISBN: 0-13-047320-0
Pages: 688


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

Top

 



Oracle PL. SQL Interactive Workbook
Oracle PL/SQL Interactive Workbook (2nd Edition)
ISBN: 0130473200
EAN: 2147483647
Year: 2002
Pages: 146

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net