Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) - page 1
- Cover
- Cover
- Table of Contents
- Dedication
- Forward
- Preface
- Structure of This Book
- Audience
- Conventions Used in This Book
- Which Platform or Version?
- About the Disk
- Comments and Questions
- Acknowledgments
- Part I - Programming in PLSQL
- Chapter 1 - Introduction to PLSQL
- 1.2 The Concept of Programming in Oracle Applications
- 1.3 The Origins of PLSQL
- 1.4 PLSQL Versions
- 1.5 Advice for Oracle Programmers
- 1.6 A Few of My Favorite (PLSQL) Things
- 1.7 Best Practices for PLSQL Excellence
- Chapter 2 - PLSQL Language Fundamentals
- 2.2 Identifiers
- 2.3 Literals
- 2.4 The Semicolon Delimiter
- 2.5 Comments
- 2.6 The PRAGMA Keyword
- 2.7 Block Structure
- Chapter 3 - Effective Coding Style
- 3.2 Formatting SQL Statements
- 3.3 Formatting Control Structures
- 3.4 Formatting PLSQL Blocks
- 3.5 Formatting Packages
- 3.6 Using Comments Effectively
- 3.7 Documenting the Entire Package
- Part II - PLSQL Language Elements
- Chapter 4 - Variables and Program Data
- 4.2 Scalar Datatypes
- 4.3 NULLS in PLSQL
- 4.4 Variable Declarations
- 4.5 Anchored Declarations
- 4.6 Programmer-Defined Subtypes
- 4.7 Tips for Creating and Using Variables
- Chapter 5 - Conditional and Sequential Control
- 5.2 Sequential Control Statements
- Chapter 6 - Database Interaction and Cursors
- 6.2 Cursors in PLSQL
- 6.3 Implicit and Explicit Cursors
- 6.4 Declaring Cursors
- 6.5 Opening Cursors
- 6.6 Fetching from Cursors
- 6.7 Column Aliases in Cursors
- 6.8 Closing Cursors
- 6.9 Cursor Attributes
- 6.10 Cursor Parameters
- 6.11 SELECT FOR UPDATE in Cursors
- 6.12 Cursor Variables
- 6.13 Working with Cursors
- Chapter 7 - Loops
- 7.2 The Simple Loop
- 7.3 The Numeric FOR Loop
- 7.4 The Cursor FOR Loop
- 7.5 The WHILE Loop
- 7.6 Managing Loop Execution
- 7.7 Tips for PLSQL Loops
- Chapter 8 - Execption Handling
- 8.2 The Exception Section
- 8.3 Types of Exceptions
- 8.4 Determining Exception-Handling Behavior
- 8.5 Raising an Exception
- 8.6 Handling Exceptions
- 8.7 Client-Server Error Communication
- 8.8 NO_DATA_FOUND: Multipurpose Exception
- 8.9 Exception Handler as IF Statement
- 8.10 RAISE Nothing but Exceptions
- Chapter 9 - Records in PLSQL
- 9.2 Table-Based Records
- 9.3 Cursor-Based Records
- 9.4 Programmer-Defined Records
- 9.5 Assigning Values to and from Records
