Oracle Database 11g PL/SQL Programming

Oracle Database 11g PL/SQL Programming

4.14 (35 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


Design Feature-Rich PL/SQL ApplicationsDeliver 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
show more

Product details

  • Paperback | 835 pages
  • 193 x 226 x 43mm | 1,460g
  • Osborne/McGraw-Hill
  • New York, United States
  • English
  • 75 Illustrations, unspecified
  • 0071494456
  • 9780071494458
  • 436,678

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

show more

About Michael McLaughlin

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.
show more

Rating details

35 ratings
4.14 out of 5 stars
5 37% (13)
4 46% (16)
3 14% (5)
2 0% (0)
1 3% (1)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X