Oracle Database 10g PL/SQL Programming

You are currently responding to the WTGOOG promotion.
If you wish to view a different promotion, please enter your Promotion Code here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.

SIGN UP TODAY


Date

October 7, 2004

Format

Paperback, 896 pages

Other Formats


ISBN

0072230665 / 9780072230666

$

Your Price

46.39

List Price

57.99



Overview


Main description

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.


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


Back cover copy

Write Robust PL/SQL Applications

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. 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/SQL 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





Copyright 2013 McGraw-Hill Global Education Holdings, LLC

WELCOME!

Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.



Yes, I want to receive other special offer.