Oracle Database 10g PL/SQL Programming / Edition 1

by Michael McLaughlin, Scott Urman, Ron Hardman

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

The essential desktop reference for PL/SQL revised and expanded for Oracle Database 10g


Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.

Product Details

ISBN-13:	9780072230666
Publisher:	McGraw Hill LLC
Publication date:	08/13/2004
Series:	Oracle Press
Pages:	896
Product dimensions:	7.30(w) x 9.20(h) x 1.72(d)

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books.He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.

Scott Urman (Foster City, CA) is a senior member of the diagnostic and defect technical staff in the Language Group of Oracle Support Services, where he aids users of Oracle's various language products (PL/SQL, OCI, and the Oracle precompilers). In addition, he reviews Oracle technical documentation, writes white papers on Oracle languages, and makes technical presentations both inside Oracle and at meetings of Oracle User's Groups. Scott is the best-selling author of Oracle Press' Oracle PL/SQL Programming and Oracle8 PL/SQL Programming.

Table of Contents

PART I: Introduction
Chapter 1: Introduction to PL/SQL
Chapter 2: Using SQL*Plus and JDeveloper
Chapter 3: PL/SQL Basics
Chapter 4: Using SQL with PL/SQL
Chapter 5: Records
Chapter 6: Collections
Chapter 7: Error Handling
Chapter 8: Creating Procedures, Functions, and Packages
Chapter 9: Using Procedures, Functions, and Packages
Chapter 10: Database Triggers
PART II: Advanced PL/SQL Features
Chapter 11: Intersession Communication
Chapter 12: External Routines
Chapter 13: Dynamic SQL
Chapter 14: Introduction to Objects
Chapter 15: Objects in the Database
Chapter 16: Large Objects
Chapter 17: Scheduling Tasks
PART III: Appendixes
Appendix A: PL/SQL Reserved Words
Appendix B: Guide to Supplied Packages