Oracle Database 11g PL/SQL Programming

Oracle Database 11g PL/SQL Programming
By:McLaughlin, Michael;
Pub Date:April 11th 2008
Format:Paperback 835 pages
eBook Available: View eBook Details
ISBN:0071494456 / 9780071494458
Regular Price:$65.00
Your Price:$52.00 ADD TO CART
More Information




Main 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


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


Backcover

Author Information

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Nov 3rd, 2015
Your Price: $35.00
Owl Image

Date: Oct 22nd, 2015
Your Price: $40.00
Owl Image

Date: Sep 11th, 2015
Your Price: $50.00
Owl Image

Date: Sep 2nd, 2015
Your Price: $50.00
Owl Image

Date: Aug 24th, 2015
Your Price: $90.00
Owl Image

Date: Jul 10th, 2015
Your Price: $40.00
Owl Image

Date: Jun 30th, 2015
Your Price: $40.00
Owl Image

Date: May 22nd, 2015
Your Price: $60.00
Owl Image

Date: May 18th, 2015
Your Price: $60.00
Owl Image

Date: Feb 12th, 2015
Your Price: $60.00
Owl Image

Date: Jan 30th, 2015
Your Price: $40.00
Owl Image

Date: Jan 27th, 2015
Your Price: $40.00
Owl Image

Date: Jan 27th, 2015
Your Price: $40.00
Owl Image

Date: Jan 27th, 2015
Your Price: $40.00
Owl Image

Date: Jan 27th, 2015
Your Price: $40.00