Oracle Database 11g PL/SQL Programming

by McLaughlin, Michael

• ISBN13: 9780071494458
• ISBN10: 0071494456
• Edition: 1st
• Format: Paperback
• Copyright: 2008-04-11
• Publisher: McGraw-Hill Education

Summary

Design Feature-Rich PL/SQL Applications 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

Author Biography

Michael McLaughlin is a professor of Computer Information Technology at BYU-Idaho, the author of Oracle Database 10g Express Edition PHP Web Programming, and coauthor of the previous edition of this book. He has been working with PL/SQL since release 1.

Table of Contents

PL/SQL Fundamentals

Oracle PL/SQL Overview

PL/SQL Basics

Language Fundamentals

Control Structures

Error Management

PL/SQL Programming

Functions and Procedures

Collections

Large Objects

Packages

Triggers

PL/SQL Advanced Programming

Dynamic SQL

Intersession Communication

External Procedures

Object Types

Java Libraries

Web Application Development

Appendixes

Oracle Database Administration Primer

Oracle Database SQL Primer

PHP Primer

Oracle Database Java Primer

Regular Expression Primer

Wrapping PL/SQL Code Primer

PL/SQL Hierarchical Profiler Primer

PL/Scope

PL/SQL Reserved Words and Keywords

PL/SQL Built-in Functions

Index

Table of Contents provided by Publisher. All Rights Reserved.