Oracle Database 12c PL/SQL Advanced Programming Techniques

Overview

Take Your PL/SQL Programming Skills to the Next Level

Build robust database-centric PL/SQL applications quickly and effectively. Oracle Database 12c PL/SQL Advanced Programming Techniques shows you how to write and deploy Java libraries inside Oracle Database 12c, use the utl_file and DBMS_SCHEDULER packages, and create external tables and external procedures. Application security, performance tuning, and Oracle Database In-Memory are also ...

See more details below
Sending request ...

More About This Book

Overview

Take Your PL/SQL Programming Skills to the Next Level

Build robust database-centric PL/SQL applications quickly and effectively. Oracle Database 12c PL/SQL Advanced Programming Techniques shows you how to write and deploy Java libraries inside Oracle Database 12c, use the utl_file and DBMS_SCHEDULER packages, and create external tables and external procedures. Application security, performance tuning, and Oracle Database In-Memory are also covered in this Oracle Press guide.

  • Configure, deploy, and troubleshoot Java libraries for Oracle object types
  • Use the utl_file package to manage unstructured and structured data
  • Develop and deploy Java I/O libraries and wrap them with PL/SQL
  • Create and use external tables
  • Implement high-speed data transfer
  • Harden database systems and develop secure applications
  • Manage complex schedules and jobs with the DBMS_SCHEDULER package
  • Optimize PL/SQL for use in performance tuning
  • Create and deploy external procedures
  • Implement the Oracle Database In-Memory column store feature
Read More Show Less

Product Details

  • ISBN-13: 9780071835145
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 11/14/2014
  • Edition number: 1
  • Pages: 448

Meet the Author

Michael McLaughlin, Oracle ACE (Rexburg, ID) is a professor at BYU – Idaho in the Computer Information Technology Department of the Business and Communications School. He is the author of Oracle Database 12c PL/SQL Programming, MySQL Workbench, and several other Oracle Press books.

John Harper (Lehi, UT) is a principal database engineer for the Church of Jesus Christ of Latter-day Saints and the co-author, with Michael McLaughlin, of Oracle Database 11g PL/SQL Programming Workbook.

Read More Show Less

Table of Contents

Section 1 - Java in the Database
Chapter 1. Functions & Procedures
Chapter 2. Object Types
Section 2 - File I/O
Chapter 3. UTL_FILE Package
Chapter 4. Java I/O
Chapter 5. External Tables
Chapter 6. Data Pump & Streams
Section 3 - Application Security
Chapter 7. Security by Design
Chapter 8. Developing Applications
Section 4 – Applied Technologies
Chapter 9. Intersession Communication
Chapter 10. DBMS_SCHEDULE R Package
Chapter 11. External Procedures
Chapter 12. PL/SQL in TimesTen
Appendixes
Appendix A. Java Primer
Appendix B. Mastery Check

Read More Show Less
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)