
Oracle Database 12c PL/SQL Advanced Programming Techniques
McGraw-Hill Professional (Publisher)
Published on 16. December 2014
Book
Paperback/Softback
416 pages
978-0-07-183514-5 (ISBN)
Description
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 LevelBuild 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
Take Your PL/SQL Programming Skills to the Next LevelBuild 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
More details
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
84 Illustrations
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 22 mm
Weight
777 gr
ISBN-13
978-0-07-183514-5 (9780071835145)
Schweitzer Classification
Other editions
Additional editions

Michael McLaughlin | John Harper
Oracle Database 12c PL/SQL Advanced Programming Techniques
E-Book
11/2014
1st Edition
McGraw-Hill Education
€123.77
Available for download
Persons
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.
Content
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
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