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.

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

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.

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