Oracle Database 12c PL/SQL Advanced Programming Techniques
- 4h 43m
- John Harper, Michael McLaughlin
- Oracle Press
- 2015
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
About the Authors
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.
In this Book
-
Java Functions and Procedures
-
Object Types
-
utl_file Package
-
Java I/O Libraries
-
External Tables
-
High-Speed Data Transfer
-
Database Security
-
Developing Secure Applications
-
dbms_scheduler Package
-
Optimizing Using PL/SQL
-
External Procedures
-
In-Memory Column Store
