Table of content
|
Oracle PL. SQL Interactive Workbook Authors: Rosenzweig B., Silvestrova E Published year: 2002 Pages: 1/146 |
 |
- 1
- 2
- Main
- 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
- 1
- 2
|
Oracle PL. SQL Interactive Workbook Authors: Rosenzweig B., Silvestrova E Published year: 2002 Pages: 1/146 |
|