Oracle Database 12c PL/SQL Programming
29%
off

Oracle Database 12c PL/SQL Programming

3.6 (5 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?

Description

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
show more

Product details

  • Paperback | 1192 pages
  • 188 x 226 x 66mm | 2,004g
  • MCGRAW-HILL Professional
  • United States
  • English
  • 176 Illustrations, unspecified
  • 0071812431
  • 9780071812436
  • 1,323,272

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
show more

About Michael McLaughlin

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.
show more

Rating details

5 ratings
3.6 out of 5 stars
5 0% (0)
4 60% (3)
3 40% (2)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X