Oracle Database 11g PL/SQL Programming Workbook

You are currently responding to the WTGOOG promotion.
If you wish to view a different promotion, please enter your Promotion Code here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.

SIGN UP TODAY


Date

January 20, 2010

Format

Electronic book text, 512 pages

Other Formats


ISBN

0071770410 / 9780071770415

Adobe Digital Editions® is required to view your downloaded eBooks.
Click here to get Adobe Digital Editions
To learn more about eBooks please see our eBook FAQ.


If you're having problems installing due to firewall issues please go here:
http://kb2.adobe.com/cps/403/kb403051.html

$

Your Price

36.40

List Price

52.00



Overview


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


Author comments

Michael McLaughlin is a professor at Brigham Young University-Idaho in the Computer Information Technology Department of the Business and Communication School. He is the author of Oracle Database 11g PL/SQL Programming and other titles.

John M. Harper is a database professional with 10 years of Oracle experience. He is currently a senior lead engineer at the Church of Jesus Christ of Latter-day Saints.





Copyright 2013 McGraw-Hill Global Education Holdings, LLC

WELCOME!

Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Happy shopping! And thank you for visiting McGraw-Hill Professional.