Oracle 10g Developer : PL/SQL Programming

by Casteel, Joan

• ISBN13: 9781423901365
• ISBN10: 1423901363
• Additional ISBN(s): 9780619159092, 9781133947363
• Edition: CD
• Format: Paperback
• Copyright: 2007-08-15
• Publisher: Cengage Learning
• More Book Details
• Purchase Benefits

Summary

Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. With real-world examples and a straightforward writing style, this is a valuable resource for anyone preparing for the new Oracle Certification exam, or simply looking to master the PL/SQL programming language with Oracle.

Table of Contents

Introduction to PL/SQL

Handling Data in PL/SQL blocks

PL/SQL Processing

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages

Introduction to Dynamic SQL and Object Technology

Performance Tuning

ppendices

Tables for Brewbean?s Database

Procedure Builder

TOAD (Tool for Oracle Application Developers)

PL/SQL and Oracle9i Developer Forms (available at www.course.com via the ?Student Downloads? link on the Web page for this textbook)

Table of Contents provided by Publisher. All Rights Reserved.