Oracle Database 11g PL/SQL Programming / Edition 1

Oracle Database 11g PL/SQL Programming / Edition 1

2.5 4
by Michael McLaughlin
     
 

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780071494458
Publisher:
McGraw-Hill Professional Publishing
Publication date:
03/21/2008
Series:
Oracle Press Series
Pages:
835
Sales rank:
827,194
Product dimensions:
7.60(w) x 8.90(h) x 1.70(d)

Related Subjects

Table of Contents

Part I: PL/SQL Fundamentals

Chapter 1. Oracle PL/SQL Overview

Chapter 2. PL/SQL Basics

Chapter 3. Language Fundamentals

Chapter 4. Control Structures

Chapter 5. Error Management

Part II: PL/SQL Programming

Chapter 6. Functions and Procedures

Chapter 7. Collections

Chapter 8. Large Objects

Chapter 9. Packages

Chapter 10. Triggers

Part III: PL/SQL Advanced Programming

Chapter 11. Dynamic SQL

Chapter 12. Intersession Communication

Chapter 13. External Procedures

Chapter 14. Object Types

Chapter 15. Java Libraries

Chapter 16. Web Application Development

Part IV: Appendixes

Appendix A. Oracle Database Administration Primer

Appendix B. Oracle Database SQL Primer

Appendix C. PHP Primer

Appendix D. Oracle Database Java Primer

Appendix E. Regular Expression Primer

Appendix F. Wrapping PL/SQL Code Primer

Appendix G. PL/SQL Hierarchical Profiler Primer

Appendix H. PL/Scope

Appendix I. PL/SQL Reserved Words and Keywords

Appendix J. PL/SQL Built-in Functions

Index

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >