Sign in  |  Register
Advanced search
Publication Cover

CITATION

McLaughlin, Michael. Oracle Database 11g PL/SQL Programming. US: McGraw-Hill Osborne Media, 2008.

Oracle Database 11g PL/SQL Programming

Authors: Michael McLaughlin

Published:  March 2008

eISBN: 9780071643566 0071643567 | ISBN: 9780071494458
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: PL/SQL Fundamentals
  • 1 Oracle PL/SQL Overview
  • History and Background
  • Architecture
  • Basic Block Structures
  • Oracle 10g New Features
  • Oracle 11g New Features
  • Summary
  • 2 PL/SQL Basics
  • Oracle PL/SQL Block Structure
  • Variables, Assignments, and Operators
  • Control Structures
  • Stored Functions, Procedures, and Packages
  • Transaction Scope
  • Database Triggers
  • Summary
  • 3 Language Fundamentals
  • Character and Lexical Units
  • Block Structures
  • Variable Types
  • Variable Scope
  • Summary
  • 4 Control Structures
  • Conditional Statements
  • Iterative Statements
  • Cursor Structures
  • Bulk Statements
  • Summary
  • 5 Error Management
  • Exception Types and Scope
  • Exception Management Built-in Functions
  • User-Defined Exceptions
  • Exception Stack Functions
  • Database Trigger Exception Management
  • Summary
  • Part II: PL/SQL Programming
  • 6 Functions and Procedures
  • Function and Procedure Architecture
  • Transaction Scope
  • Calling Subroutines
  • Functions
  • Procedures
  • Summary
  • 7 Collections
  • Collection Types
  • Collection Set Operators
  • Collection API
  • Summary
  • 8 Large Objects
  • Character Large Objects: CLOB and NCLOB Datatypes
  • Binary Large Objects: BLOB Datatype
  • SecureFiles
  • Binary Files: BFILE Datatype
  • DBMS_LOB Package
  • Summary
  • 9 Packages
  • Package Architecture
  • Package Specification
  • Package Body
  • Definer vs. Invoker Rights
  • Managing Packages in the Database Catalog
  • Summary
  • 10 Triggers
  • Introduction to Triggers
  • Database Trigger Architecture
  • Data Definition Language Triggers
  • Data Manipulation Language Triggers
  • Compound Triggers
  • Instead-of Triggers
  • System or Database Event Triggers
  • Trigger Restrictions
  • Summary
  • Part III: PL/SQL Advanced Programming
  • 11 Dynamic SQL
  • Dynamic SQL Architecture
  • Native Dynamic SQL (NDS)
  • DBMS_SQL Package
  • Summary
  • 12 Intersession Communication
  • Introducing Intersession Communication
  • The DBMS_PIPE Built-in Package
  • DBMS_ALERT Built-in Package
  • Summary
  • 13 External Procedures
  • Introducing External Procedures
  • Working with External Procedures
  • Troubleshooting the Shared Library
  • Summary
  • 14 Object Types
  • Objects Basics
  • Inheritance and Polymorphism
  • Implementing Collection Object Bodies
  • Summary
  • 15 Java Libraries
  • Oracle 11g JVM New Features
  • Java Architecture
  • Oracle Java Connection Types
  • Building Java Class Libraries in Oracle
  • Mapping Oracle Types
  • Summary
  • 16 Web Application Development
  • PL/SQL Web Server Architecture
  • Configuring the Standalone Oracle HTTP Server
  • Configuring the XML DB Server
  • Comparing Web-Enabled PL/SQL Procedures and PSPs
  • Creating Web-Enabled PL/SQL Stored Procedures
  • Building and Accessing PL/SQL Server Pages (PSPs)
  • Summary
  • Part IV: Appendixes
  • A: Oracle Database Administration Primer
  • Oracle Database Architecture
  • Starting and Stopping the Oracle Database
  • Starting and Stopping the Oracle Listener
  • Oracle Roles and Privileges
  • Accessing and Using the SQL*Plus Interface
  • Summary
  • B: Oracle Database SQL Primer
  • Oracle SQL*Plus Datatypes
  • Data Definition Language (DDL)
  • Data Query Language (DQL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Summary
  • C: PHP Primer
  • History and Background
  • Developing Web Programming Solutions
  • Summary
  • D: Oracle Database Java Primer
  • Java and JDBC Architecture
  • Configuring the Oracle Java Environment
  • Java Programming Language Primer
  • Testing a Client-Side or Thin-Driver JDBC Connection
  • Accessing Scalar Variables
  • Writing and Accessing Large Objects
  • Summary
  • E: Regular Expression Primer
  • Introduction to Regular Expressions
  • Oracle 11g Regular Expression Implementation
  • Using Regular Expressions
  • Summary
  • F: Wrapping PL/SQL Code Primer
  • Limitations of Wrapping PL/SQL
  • Using the Wrap Command-Line Utility
  • Using the DBMS_DDL Command-Line Utility
  • Summary
  • G: PL/SQL Hierarchical Profiler Primer
  • Configuring the Schema
  • Collecting Profiler Data
  • Understanding Profiler Data
  • Using the plshprof Command-Line Utility
  • Summary
  • H: PL/Scope
  • Configuring PL/Scope Data Collection
  • Viewing PL/Scope Collected Data
  • Summary
  • I: PL/SQL Reserved Words and Keywords
  • Summary
  • J: PL/SQL Built-in Functions
  • Character Functions
  • Datatype Conversion
  • Error Reporting
  • Miscellaneous
  • Number
  • Summary
  • Index