 |
Author(s) : Michael McLaughlin
Publisher : McGraw-Hill Osborne Media; 1 edition
Date : 2008
Pages : 835
Format : PDF
ISBN-10 : 0071494456
ISBN-13 : 978-0071494458
|
Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.
* Create, debug, and manage Oracle-driven PL/SQL programs
* Use PL/SQL structures, delimiters, operators, variables, and statements
* Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
* Work with functions, procedures, packages, collections, and triggers
* Define and deploy varray, nested table, and associative array data types
* Handle external routines, object types, large objects, and secure files
* Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
* Call external procedures through Oracle Net Services and PL/SQL wrappers
* Integrate internal and server-side Java class libraries using Oracle JVM
* Develop robust Web applications using PL/SQL Gateway and Web Toolkit
Introduction
This book is designed to be read from beginning to end by those new to
PL/SQL. Part I covers PL/SQL fundamentals. Part II covers the backbone
of the programming language, which consists of functions, procedures,
packages, triggers, and large objects. Part III dives into some advanced
topics that should help you immediately with your development projects.
The appendixes in Part IV provide primers on Oracle DBA tasks, SQL programming,
PHP scripting, Java development, regular expressions, and wrapping PL/SQL. Introductory
primers are provided to help you learn about the PL/SQL Hierarchical Profiler and PL/Scope.
There is also an appendix that reviews reserved words and built-in functions that support
your programming tasks.
Download Link