Oracle PL/SQL Interactive Workbook (2nd Edition)
Oracle PL/SQL Interactive Workbook (2nd Edition)
ISBN: 0130473200
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 146
Pages: 146
Authors: Benjamin Rosenzweig, Elena Silvestrova
- 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
Oracle PL/SQL Interactive Workbook (2nd Edition)
ISBN: 0130473200
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 146
Pages: 146
Authors: Benjamin Rosenzweig, Elena Silvestrova