Oracle Database 12c: The Complete Reference

  • 21h 9m
  • Bob Bryla, Kevin Loney
  • Oracle Press
  • 2014

Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions.

  • Set up Oracle Database 12c or upgrade from an earlier version
  • Design Oracle databases and plan for application implementation
  • Construct SQL and SQL*Plus statements and execute powerful queries
  • Secure data with roles, privileges, virtualization, and encryption
  • Move data with SQL*Loader and Oracle Data Pump
  • Restore databases using flashback and the Oracle Database Automatic Undo Management feature
  • Build and deploy PL/SQL triggers, procedures, and packages
  • Work with Oracle pluggable and container databases
  • Develop database applications using Java, JDBC, and XML
  • Optimize performance with Oracle Real Application Clusters

About the Authors

Bob Bryla has more than 20 years of experience in MIS, ranging from database and data warehouse design to system administration on multiple hardware platforms. He is currently lead designer and data analyst for Land’s End's online store database and handles the DBA activities on Land’s End Oracle Internet databases.

Kevin Loney was named Consultant of the Year by Oracle Magazine in 2002. He is an internationally recognized expert in the design, development, and administration and tuning of Oracle databases. An Oracle developer and database administrator since 1987, Loney has designed and implemented both transactional processing systems and data warehouses.

In this Book

  • Oracle Database 12c Architecture Options
  • Installing Oracle Database 12c and Creating a Database
  • Upgrading to Oracle Database 12c
  • Planning Oracle Applications—Approaches, Risks, and Standards
  • The Basic Parts of Speech in SQL
  • Basic SQL*Plus Reports and Commands
  • Getting Text Information and Changing It
  • Searching for Regular Expressions
  • Playing the Numbers
  • Dates: Then, Now, and the Difference
  • Conversion and Transformation Functions
  • Grouping Things Together
  • When One Query Depends on Another
  • Some Complex Possibilities
  • Changing Data: INSERT, DELETE, UPDATE and MERGE
  • DECODE and CASE: IF, THEN, and ELSE in SQL
  • Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
  • Partitioning
  • Basic Oracle Security
  • Advanced Security—Virtual Private Databases
  • Advanced Security—Transparent Data Encryption
  • Working with Tablespaces
  • Using SQL*Loader to Load Data
  • Using Data Pump Export and Import
  • Accessing Remote Data
  • Using Materialized Views
  • Using Oracle Text for Text Searches
  • Using External Tables
  • Using Flashback Queries
  • Flashback—Tables and Databases
  • SQL Replay
  • An Introduction to PL/SQL
  • Online Application Upgrades
  • Triggers
  • Procedures, Functions, and Packages
  • Using Native Dynamic SQL and DBMS_SQL
  • PL/SQL Tuning
  • Implementing Object Types, Object Views, and Methods
  • Collectors (Nested Tables and Varying Arrays)
  • Using Large Objects
  • Advanced Object-Oriented Concepts
  • An Introduction to Java
  • JDBC Programming
  • Java Stored Procedures
  • The Hitchhiker's Guide to the Oracle Data Dictionary
  • The Hitchhiker's Guide to Tuning Applications and SQL
  • The Hitchhiker's Guide to SQL Result Cache and Client-Side Query Cache
  • Case Studies in Tuning
  • The Hitchhiker's Guide to Pluggable Databases
  • The Hitchhiker's Guide to Oracle Real Application Clusters
  • The Hitchhiker's Guide to Database Administration
  • The Hitchhiker's Guide to XML in Oracle
  • Alphabetical Reference