Overview

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.Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries

Full Product Details

Author:   Michael McLaughlin
Publisher:   McGraw-Hill Education - Europe
Imprint:   Osborne/McGraw-Hill
Dimensions:   Width: 18.80cm , Height: 6.60cm , Length: 22.60cm
Weight:   1.923kg
ISBN:  

9780071812436

ISBN 10:   0071812431
Pages:   1192
Publication Date:   16 February 2014
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

Updated TOC to FollowPart 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

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions