Oracle Database 11g PL/SQL Programming

Oracle Database 11g PL/SQL Programming

Paperback Oracle Press

By (author) Michael McLaughlin

$40.18
List price $62.47
You save $22.29 35% off

Free delivery worldwide
Available
Dispatched in 2 business days
When will my order arrive?

  • Publisher: Osborne/McGraw-Hill
  • Format: Paperback | 835 pages
  • Dimensions: 186mm x 230mm x 48mm | 1,379g
  • Publication date: 1 May 2008
  • Publication City/Country: New York
  • ISBN 10: 0071494456
  • ISBN 13: 9780071494458
  • Sales rank: 243,229

Product description

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

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

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

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