Oracle Database 11g PL/SQL Programming Workbook - Michael McLaughlin, John Harper

Oracle Database 11g PL/SQL Programming Workbook

Buch | Softcover
512 Seiten
2010
Osborne/McGraw-Hill (Verlag)
978-0-07-149369-7 (ISBN)
53,60 inkl. MwSt
Learn essential Oracle PL/SQL skills through hands-on, real-world labs, extensive examples, exercises, and projects.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Ramp Up Your PL/SQL Programming SkillsMaster 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

Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.

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

Erscheint lt. Verlag 16.3.2010
Reihe/Serie Oracle Press
Zusatzinfo 0 Illustrations, unspecified
Verlagsort New York
Sprache englisch
Maße 188 x 231 mm
Gewicht 848 g
Themenwelt Informatik Datenbanken Oracle
ISBN-10 0-07-149369-7 / 0071493697
ISBN-13 978-0-07-149369-7 / 9780071493697
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Das umfassende Handbuch

von Jürgen Sieben

Buch | Hardcover (2018)
Rheinwerk (Verlag)
69,90
Das umfassende Praxis-Handbuch

von Lutz Fröhlich

Buch | Hardcover (2021)
MITP (Verlag)
29,99