Oracle Database 10g PL/SQL Programming

Develop Database-Driven PL/SQL Applications

Scott Urman, Ron Hardman, Michael McLaughlin

862 pages, parution le 08/10/2004

Ajouter à une liste

Indisponible

Résumé

Write Robust PL/SQL Applications

Create dynamic client/server applications using PL/SQL and the comprehensi 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. Plus, you'll get insider programming tips and techniques and real-world examples from the Oracle community.

Develop, tune, and debug PL/SQL programs that access Oracle databases from a wide variety of environments
Use PL/SOL block structures, variables, datatypes, expressions, operators, and statements
Regulate and recover from errors using exceptions and exception handlers
Deploy subprograms, procedures, functions, packages, and triggers
Accomplish intersession communication with DBMS_PIPE and DBMS_ALERT
Write object-oriented PL/SQL applications
Manage large sets of data using PL/SQL records and objects
Work with Oracle Net Services, external procedures, Java libraries, and C shared libraries
Perform object-oriented programming using transient objects, inheritance, type evolution, and attribute chaining
Automate database tasks with DBMS_JOB and DBMS_SCHEDULER, and add e-mail functionality with UTL_SMTP and UTL_MAIL

L'auteur - Michael McLaughlin

Michael McLaughlin, Oracle ACE, is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on IT management, databases, and systems analysis and design. Michael is the author of Oracle Database 11g PL/SQL Programming and Oracle Database 10g Express Edition PHP Web Programming, and co-author of Oracle Database 11g PL/SQL Programming Workbook, Oracle Database 10g PL/SQL Programming, Expert Oracle PL/SQL, and Oracle Database AJAX & PHP Web Application Development. He worked at Oracle Corporation for more than eight years, most recently as the senior applications upgrade manger in E-Business Suite Release Engineering.

Sommaire

Basic PL/SQL Features
- Introduction
- PL/SQL Basics
- SQL Writing PLS/SQL
- Records and Collections
- Error Handling
- Creating Subprograms and Packages
- Using Subprograms and Packages
- Database Triggers
Advanced PL/SQL Features
- Intersession Communication
- Additional Utility Packages
- External Routines
- Dynamic SQL
- Introduction to Objects
- Objects in the Database
- Large Objects
- Advanced LOB Topics and DBMS LOB

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Oracle Press
Auteur(s)	Scott Urman, Ron Hardman, Michael McLaughlin
Parution	08/10/2004
Nb. de pages	862
Format	18,5 x 23
Couverture	Broché
Poids	1449g
Intérieur	Noir et Blanc
EAN13	9780072230666
ISBN13	978-0-07-223066-6