Oracle Database 10g PL/SQL Programming

by Ron Hardman, Michael McLaughlin, Scott Urman

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