Oracle Database 11g PL/SQL Programming Workbook (eBook)

Oracle Database 11g PL/SQL Programming Workbook
By:Harper, John; McLaughlin, Michael;
Pub Date:February 10th 2010
Format:Electronic book text 512 pages
ISBN:0071770410 / 9780071770415
Regular Price:$54.00
Your Price:$43.20 ADD TO CART
More Information




Main description

Ramp Up Your PL/SQL Programming Skills

Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.

  • Understand the Oracle development architecture and the mechanics of connections
  • Work with data types, structures, blocks, cursors, and PL/SQL semantics
  • Write, deploy, and use functions, procedures, and packages
  • Manage transactions and more
  • Use dynamic SQL statements in real-world applications
  • Support online transaction processing and data warehousing applications with external tables
  • Find syntax samples and best practices to solve problems
  • Write, deploy, and use object types

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com


Table of contents

Part I: PL/SQL Fundamentals; Chapter 1. Oracle Development Overview; Chapter 2. PL/SQL Basics; Chapter 3. Transaction Scope; Chapter 4. Error Management; Part II: PL/SQL Programming; Chapter 5. Functions; Chapter 6. Procedures; Chapter 7. Collections; Chapter 8. Packages; Chapter 9. Triggers; Chapter 10. Objects; Part III: PL/SQL Advanced Programming; Chapter 11. Dynamic SQL; Chapter 12. External Files; Part IV: Appendixes; Appendix A. Wrapping PL/SQL; Appendix B. PL/SQL Hierarchical Profiler; Appendix C. PL/Scope; Appendix D. PL/SQL Built-in Packages and Types; Appendix E. Mastery Check Answers; Index


Backcover

Author Information

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Apr 25th, 2016
Your Price: $85.00
Owl Image

Date: Apr 19th, 2016
Your Price: $80.00
Owl Image

Date: Apr 8th, 2016
Your Price: $60.00
Owl Image

Date: Dec 29th, 2015
Your Price: $99.00
Owl Image

Date: Dec 3rd, 2015
Your Price: $70.00
Owl Image

Date: Nov 13th, 2015
Your Price: $35.00
Owl Image

Date: Oct 12th, 2015
Your Price: $60.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 28th, 2015
Your Price: $90.00
Owl Image

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

Date: Aug 10th, 2015
Your Price: $60.00
Owl Image

Date: Aug 3rd, 2015
Your Price: $50.00
Owl Image

Date: Jul 30th, 2015
Your Price: $60.00
Owl Image

Date: Jul 30th, 2015
Your Price: $50.00