| | | 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 |
|
No comments:
Post a Comment