book

Oracle Database 12c PL/SQL Advanced Programming Techniques

by Michael McLaughlin, John Harper

November 2014

Intermediate to advanced

448 pages

11h 15m

English

McGraw Hill Computing

Read now

Unlock full access

Cover
Title Page
Copyright Page
Dedication
About the Authors
Contents at a Glance
Contents
Acknowledgments
Introduction
Part I Java in the Database

1 Java Functions and Procedures
OverviewOracle Database 12c JVM FeaturesJava Architecture in OracleJava Execution ControlJava Resource StorageJava Class NamesJava ResolversJava Security and PermissionsJava ThreadingOracle Java Connection TypesThe Client-Side Driver, or JDBC Thin DriverThe Oracle Call Interface Driver, or Middle-Tier Thick DriverThe Oracle Server-Side Internal Driver, or Server-Tier Thick DriverImporting Java Class LibrariesBuilding a Java FileCreating a Deterministic Java LibraryCreating a JDBC-Enabled Java LibrarySupporting ScriptsSummary
2 Object Types
OverviewCreating a Java Class with SQLDataBasic Java Class with SQLDataObject Type WrapperCreating a Java Superclass and Object TypesCreating the Java SuperclassCreating the Object TypeTesting the Java Class FileCreating a Java Subclass and Object SubtypeCreating a Java SubclassCreating the Object SubtypeTesting the Java SubclassTroubleshooting Java ClassesBuilding, Loading, and Dropping Java Class Library ObjectsUsing Java Class Library ObjectsMapping Oracle TypesSupporting ScriptsSummary
Part II File I/O
3 utl_file Package
OverviewAccessing External FilesSetting the utl_file_dir Database ParameterUsing Virtual DirectoriesReading External FilesReading Files with the utl_file PackageImplementing Best PracticesCopying, Moving, Renaming, and Removing External FilesCopying External FilesRenaming or Moving External FilesRemoving External FilesCreating and Writing to External FilesWriting Unstructured Data to External FilesWriting Structured Data to External FilesSupporting ScriptsSummary
4 Java I/O Libraries
OverviewMapping Virtual Directories to Physical DirectoriesCreating a Virtual DirectoryTranslating Virtual Names to PathsExtracting a File Path and NameSetting Java PrivilegesReading from an External DirectoryReading from an External FileWriting to an External FileDeleting from an External FileDeveloping and Deploying Java I/O LibrariesReading a DirectoryReading a FileCopying a FileDeleting a FileWriting a FileSupporting ScriptsSummary
5 External Tables
OverviewUsing External TablesCreating Virtual Directories and Granting Database PrivilegesImporting a Framework’s External TableLeveraging the Data CatalogWrapping Access to External TablesCleaning Up the External Table FilesSupporting ScriptsSummary
6 High-Speed Data Transfer
OverviewImporting and Exporting with impdp and expdpExporting Files with expdpImporting Files with impdpImporting and Exporting with dbms_datapumpSQL*LoaderSupporting ScriptsSummary
Part III Application Security
7 Database Security
OverviewLinkedIn BreachKey Points of the LinkedIn BreachSolutions to Avoid a Similar BreachTarget BreachKey Points of the Target BreachSuggested Remediation for the BreachNSA BreachKey Points of the NSA BreachSuggested Remediation for the BreachUtah Department of Technology Services BreachKey Points of the Utah DTS BreachSolutions to Avoid a Similar BreachNISTSANSPlanning and Implementing CybersecuritySeparation of DutiesSupporting ScriptsSummary
8 Developing Secure Applications
OverviewProgramming PatternsAuditing with Oracle Audit VaultSecure Application RolesProxy UsersThe Database Security SchemaThe utl_sec PackageOracle’s New Multitenant ArchitectureSanitizing SQL and PL/SQLBind Variablesdbms_assertSupporting ScriptsSummary
Part IV Applied Technologies
9 dbms_scheduler Package
OverviewDate IntervalsImmediate JobsSimple IntervalsBuilt-in IntervalsCombined Custom Intervalsdbms_scheduler View*_scheduler_jobs*_scheduler_running_jobs*_scheduler_job_run_detailsChained and Clustered JobsJob Management and SecuritySupporting ScriptsSummary
10 Optimizing Using PL/SQL
OverviewCurrent Optimization Platformsv$* Views for Performance TuningGathering StatisticsStatistics-Gathering PackageAnalyzing a Data ModelCurrent Optimization PlatformsSupporting ScriptsSummary
11 External Procedures
OverviewIntroducing External ProceduresWorking with External ProceduresDefining the extproc ArchitectureDefining extproc Oracle Net Services ConfigurationDefining the Multithreaded External Procedure AgentWorking with a C Shared LibraryTroubleshooting External ProceduresConfiguration of the Listener or EnvironmentConfiguration of the Shared Library or PL/SQL Library WrapperSupporting FilesSummary
12 In-Memory Column Store
OverviewIn-Memory Setup and ConfigurationDatabase Parameter SettingsTablespace SettingsIn-Memory Options and SyntaxPriorityDistributionCompressionQuery PerformanceCompression StatsQueriesDML PerformanceTest SetupSupporting ScriptsTest ResultsSummary
A Oracle Database Java Primer
Java and JDBC ArchitectureConfiguring the Oracle Java EnvironmentJava Programming Language PrimerJava BasicsJava Assignment OperatorsJava Conditional and Iterative StructuresJava Method DefinitionsJava try-catch BlocksTesting a Client-Side or Thin-Driver JDBC ConnectionAccessing Scalar VariablesWriting and Accessing Large ObjectsWriting and Accessing a CLOB ColumnAccessing a BFILE ColumnSupporting ScriptsSummary
Index

Overview

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780071835145

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills