---

Oracle PL/SQL Interactive Workbook (2nd Edition)

ISBN: 0130473200
EAN: 2147483647

Year: 2002
Pages: 146

Authors: Benjamin Rosenzweig, Elena Silvestrova

BUY ON AMAZON

• Main
• TOC
• 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 SQLPlus
• 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. PLSQL Concepts
• Lab 2.1 PLSQL In Client-Server Architecture
• Lab 2.2 PLSQL in SQLPlus
• Chapter 2 Test Your Thinking
• Chapter 3. General Programming Language Fundamentals
• Lab 3.1 PLSQL Programming Fundamentals
• Chapter 3 Test Your Thinking
• Chapter 4. SQL in PLSQL
• Lab 4.1 Making Use of DML in PLSQL
• 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
• PLSQL 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 PLSQL 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 PLSQL 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 Advanced Cursors
• Chapter 16 Stored Code
• Chapter 17 Triggers
• Chapter 18 Collections
• Chapter 19 Records
• Appendix B. PLSQL Formatting Guide
• PLSQL 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 PLSQL 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