TY - BOOK AU - McLaughlin, Michael AU - Harper, John M., TI - Oracle Database 12c PL/SQL advanced programming techniques: best practices for developing expert-level PL/SQL solutions SN - 9780071835145 AV - QA 76.9 .M22 2015 PY - 2015/// CY - [Place of publication not identifed] PB - [publisher not identified] KW - PL/SQL (COMPUTER PROGRAM LANGUAGE) N1 - Includes index; Part I. Java in the database -- 1. Java functions and procedures -- 2. Object types -- Part II. File I/O -- 3. utl_file Package -- 4. Java I/O libraries -- 5. External tables -- 6. High-speed data transfer -- Part III. Application security -- 7. Database security -- 8. Developing secure applications -- 9. dbms_scheduler package -- 10. Optimizing using PL/SQL -- 11. External procedures -- 12. In-memory column store N2 - "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"-- ER -