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 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.
Keywords: ORACLE PL SQL, ORACLE PL SQL PROGRAMMING, ORACLE PL SQL BEST PRACTICES, ORACLE PL SQL TUNING ORACLE PLSQL, ORACLE DATABASE, RELATIONAL DATABASES, DISTRIBUTED DATABASES, DATABASE DESIGN, ORACLE MYSQL, PL/SQL PROGRAMMING LANGUAGE, JAVA PROGRAMMING LANGUAGE, FILE I/O, APPLICATION SECURITY, FUNCTIONS, PROCEDURES, OBJECT TYPES, UTL_FILE PACKAGE, JAVA I/O, EXTERNAL TABLES, DATA PUMP, STREAMS, SECURITY BY DESIGN, DEVELOPING APPLICATIONS, INTERSESSION COMMUNICATION, DBMS_SCHEDULE R PACKAGE, EXTERNAL PROCEDURES, PL/SQL IN TIMESTEN, MYSQL WORKBENCH, ORACLE DATABASE 12C THE COMPLETE REFERENCE, ORACLE DATABASE 12C DBA HANDBOOK, ORACLE DATABASE 12C NEW FEATURES, ORACLE DATABASE 12C PL/SQL PROGRAMMING, ORACLE DATABASE 12C INSTALL, CONFIGURE & MAINTAIN LIKE A PROFESSIONAL, ORACLE DATABASE 12C SQL, OCP ORACLE DATABASE 12C ADVANCED ADMINISTRATION EXAM GUIDE, OCP UPGRADE TO ORACLE DATABASE 12C EXAM GUIDE, OCA ORACLE DATABASE 12C INSTALLATION AND ADMINISTRATION EXAM GUIDE, OCA ORACLE DATABASE 12C SQL FUNDAMENTALS I EXAM GUIDE, RUNNING ORACLE APPLICATIONS ON ORACLE EXADATA, OCP JAVA SE 7 PROGRAMMER STUDY GUIDE, OCA JAVA SE 7 PROGRAMMER I STUDY GUIDE, JAVA EE AND HTML5 ENTERPRISE APPLICATION DEVELOPMENT, OCM JAVA EE 6 ENTERPRISE ARCHITECT EXAM GUIDE, JAVA EE 7 THE BIG PICTURE, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G PL/SQL PROGRAMMING WORKBOOK, ORACLE PL/SQL PERFORMANCE TUNING TIPS & TECHNIQUES, MASTERING LAMBDAS, JAVA THE COMPLETE REFERENCE, JAVA A BEGINNER'S GUIDE