Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
ISBN: 0596514468
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 234
Pages: 234
Authors: Steven Feuerstein, Bill Pribyl
- 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
- 9.6 Record Types and Record Compatibility
- 9.7 Nested Records
- Chapter 10 - PLSQL Tables
- 10.2 Characteristics of PLSQL Tables
- 10.3 PLSQL Tables and DML Statements
- 10.4 Declaring a PLSQL Table
- 10.5 Referencing and Modifying PLSQL Table Rows
- 10.6 Filling the Rows of a PLSQL Table
- 10.7 Clearing the PLSQL Table
- 10.8 PLSQL Table Enhancements in PLSQL Release 2.3
- 10.9 Working with PLSQL Tables
- Part III - Built-In Functions
- Chapter 11 - Character Functions
- 11.2 Character Function Examples
- Chapter 12 - Date Functions
- 12.2 Date Function Examples
- Chapter 13 - Numeric, LOB, and Miscellaneous Functions
- 13.2 LOB Function Descriptions
- 13.3 Miscellaneous Function Descriptions
- Chapter 14 - Conversion Functions
- 14.2 Conversion Function Descriptions
- 14.3 Conversion Function Examples
- Part IV - Modular Code
- Chapter 15 - Procedures and Functions
- 15.2 Review of PLSQL Block Structure
- 15.3 The Anonymous PLSQL Block
- 15.4 Procedures
- 15.5 Functions
- 15.6 Parameters
- 15.7 Local Modules
- 15.8 Module Overloading
- 15.9 Forward Declarations
- 15.10 Go Forth and Modularize
- Chapter 16 - Packages
- 16.2 Overview of Package Structure
- 16.3 The Package Specification
- 16.4 The Package Body
- 16.5 Package Data
- 16.6 Package Initialization
- Chapter 17 - Calling PLSQL Functions in SQL
- 17.2 Syntax for Calling Stored Functions in SQL
- 17.3 Requirements for Stored Functions in SQL
- 17.4 Restrictions on PLSQL Functions in SQL
- 17.5 Calling Packaged Functions in SQL
- 17.6 ColumnFunction Name Precedence
- 17.7 Realities: Calling PLSQL Functions in SQL
- 17.8 Examples of Embedded PLSQL
- Part V - New PLSQL8 Features
- Chapter 18 - Object Types
- 18.2 Oracle Objects Example
- 18.3 Syntax for Creating Object Types
- 18.4 Manipulating Objects in PLSQL and SQL
- 18.5 Modifying Persistent Objects
- 18.6 Object Housekeeping
- 18.7 Making the Objects Option Work
- Chapter 19 - Nested Tables and VARRAYs
- 19.2 Creating the New Collections
- 19.3 Syntax for Declaring Collection Datatypes
- 19.4 Using Collections
- 19.5 Collection Pseudo-Functions
- 19.6 Collection Built-Ins
- 19.7 Example: PLSQL-to-Server Integration
- 19.8 Collections Housekeeping
- 19.9 Which Collection Type Should I Use?
- Chapter 20 - Object Views
- 20.2 INSTEAD OF Triggers
- 20.3 Syntax for Object Views
- 20.4 Differences Between Object Views and Object Tables
- 20.5 Not All Views with Objects Are Object Views
- 20.6 Schema Evolution
- 20.7 Object Views Housekeeping
- 20.8 Postscript: Using the BFILE Datatype
- Chapter 21 - External Procedures
- 21.2 Steps in Creating an External Procedure
- 21.3 Syntax for External Procedures
- 21.4 Mapping Parameters
- 21.5 OCI Service Routines
- 21.6 External Procedure Housekeeping
- 21.7 Examples
- Part VI - Making PLSQL Programs Work
- Chapter 22 - Code Design Tips
- 22.2 Build the Most Functional Functions
- 22.3 Take Full Advantage of Local Modularization
- 22.4 Be Wary of Modules Without Any Parameters
- 22.5 Ceate Independent Modules
- 22.6 Construct Abstract Data Types (ADTs)
- 22.7 Tips for Parameter Design
- Chapter 23 - Managing Code in the Database
- 23.2 Transaction Integrity and Execute Authority
- 23.3 Module Validation and Dependency Management
- 23.4 Remote Procedure Calls
- 23.5 Managing Stored Objects with SQLPlus
- 23.6 Using SQL to Examine Stored Objects
- 23.7 Encrypting Stored Code
- Chapter 24 - Debugging PLSQL
- 24.2 Debugging Tips and Strategies
- Chapter 25 - Tuning PLSQL Applications
- 25.2 Tuning Access to Compiled Code
- 25.3 Tuning Access to Your Data
- 25.4 Tuning Your Algorithms
- 25.5 Overview of PLSQL8 Enhancements
- Chapter 26 - Tracing PLSQL Execution
- 26.2 Tracing for Production Support
- 26.3 Free Format Filtering
- 26.4 Structured Interface Filtering
- 26.5 Quick-and-Dirty Tracing
- Part VII - Appendixes
- Appendix A - What s on the Companion Disk?
- A.2 Using the Guide
- Appendix B - Called Stored Procedures from PLSQL Version 1.1
- B.2 Restrictions on Calling Stored Procedures
- Appendix C - Built-In Packages
- C.2 DBMS_ALERT
- C.3 Oracle AQ, the Advanced Queueing Facility
- C.4 DBMS_DDL
- C.5 DBMS_JOB
- C.6 DBMS_LOB (PLSQL8 Only)
- C.7 DBMS_LOCK
- C.8 DBMS_MAIL
- C.9 DBMS_OUTPUT
- C.10 DBMS_PIPE
- C.11 DBMS_ROWID (PLSQL8 Only)
- C.12 DBMS_SESSION
- C.13 DBMS_SNAPSHOT
- C.14 DBMS_SQL
- C.15 DBMS_TRANSACTION
- C.16 DBMS_UTILITY
- C.17 UTL_FILE
- Symbols and Numbers
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- Y
- Z
Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
ISBN: 0596514468
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 234
Pages: 234
Authors: Steven Feuerstein, Bill Pribyl