Sign in  |  Register
Advanced search
Publication Cover

CITATION

McLaughlin, Michael and Harper, John. Oracle Database 11g PL/SQL Programming Workbook. US: McGraw-Hill Osborne Media, 2010.

Oracle Database 11g PL/SQL Programming Workbook

Authors: Michael McLaughlin and John Harper

Published:  January 2010

eISBN: 9780071770415 0071770410 | ISBN: 9780071493697
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: PL/SQL Fundamentals
  • 1 Oracle Development Overview
  • History and Background
  • Architecture
  • Downloadable Code
  • Summary
  • 2 PL/SQL Basics
  • PL/SQL Blocks
  • Variables: Types, Assignments, and Operators
  • Control Structures
  • Bulk Operations
  • Downloadable Code
  • Summary
  • 3 Transaction Scope
  • The Database Acid Test
  • Multiversioned Concurrency Control
  • Savepoints, Commits, and Transaction Rollbacks
  • DML Locking and Isolation Control
  • Invoker and Definer Rights
  • Summary
  • 4 Error Management
  • Error Types
  • PL/SQL Instrumentation
  • Summary
  • Part II: PL/SQL Programming
  • 5 Functions
  • Function Architecture
  • Function Development
  • Downloadable Code
  • Summary
  • 6 Procedures
  • Procedure Architecture
  • Procedure Development
  • Summary
  • 7 Collections
  • Scalar Collections
  • Object Type Collections
  • Record Type Collections
  • Downloadable Code
  • Summary
  • 8 Packages
  • Package Architecture
  • Package Specifications
  • Bodiless Packages
  • Package Bodies
  • %TYPE and %ROWTYPE
  • Modular Programming
  • Overloading
  • Greater Security
  • Definer and Invoker Rights
  • Downloadable Code
  • Conclusion
  • 9 Triggers
  • Trigger Architecture
  • Trigger Firing Order
  • Trigger Types
  • Security and Oracle Fine Grained Auditing
  • Distributed Data Integrity
  • Downloadable Code
  • Conclusion
  • 10 Objects
  • Basic Declaration, Implementation, and Use
  • Comparing Objects
  • Inheritance and Polymorphism
  • Object Collections
  • Downloadable Code
  • Summary
  • Part III: PL/SQL Advanced Programming
  • 11 Dynamic SQL
  • Native Dynamic SQL
  • DBMS_SQL Package
  • Downloadable Code
  • Summary
  • 12 External Files
  • External Table Architecture
  • Importing CLOBs
  • Downloadable Code
  • Summary
  • Part IV: Appendixes
  • A: Wrapping PL/SQL
  • Limitations of Wrapping PL/SQL
  • Using the wrap Command Line Utility
  • Using the DBMS_DDL Command Line Utility
  • WRAP Function
  • CREATE_WRAPPED Procedure
  • Summary
  • B: PL/SQL Hierarchical Profiler
  • Configuring the Schema
  • Collecting Profiler Data
  • Understanding Profiler Data
  • C: PL/Scope
  • Configuring PL/Scope Data Collection
  • D: PL/SQL Built-in Packages and Types
  • Examples of Package Usage
  • E: Mastery Check Answers
  • Chapter 1
  • Chapter 2
  • Chapter 3
  • Chapter 4
  • Chapter 5
  • Chapter 6
  • Chapter 7
  • Chapter 8
  • Chapter 9
  • Chapter 10
  • Chapter 11
  • Chapter 12
  • Index