Oracle Database 12c PL/SQL Advanced Programming Techniques

by ;
  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 11/10/2014
  • Publisher: McGraw-Hill Education
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $75.00 Save up to $11.25
  • Buy New
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


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

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
Appendix A. Java Primer
Appendix B. Mastery Check

Rewards Program

Write a Review