SkillBuilders Welcome  |  Log in
All Oracle Classes

Oracle 12c New Features for Developers

2 Day Onsite or 14 Hour Online Hands-On Training

Participants will  be introduced to the new and improved features of Oracle 12c that concern Application Developers. Several exercises involve practice using new items discussed in the course. Objectives include:

  • Be aware of Oracle 12c features that are geared to developers.
  • Be familiar with the architectural changes and other system-level features that have been added and/or improved in Oracle 12c.
  • Become aware of some 12c DBA oriented features that will impact developers.
  • Use new Oracle 12c SQL and PL/SQL features.
  • Create tables using Identity columns and columns based upon Sequences.
  • Build “Top-N” queries to support user requests.
  • Use Regular-Expression-based Pattern matching to improve data selection.
  • Process time-period sensitive data appropriately with temporal validity features.
  • Improve “join” capabilities using expanded Oracle outer-join operator (+). CROSS_APPLY/OUTER_APPLY, and LATERAL inline views.
  • Improve performance of some SQL be calling PL/SQL defined in WITH clause or using PRAGMA UDF.
  • Utilize improvements in PL/SQL result cache.
  • Be aware of increased usability of Edition-Based Redefinition (EBR) in Oracle 12c.
Average Student Rating:

Introduction to Oracle 12c

  • Overview of Oracle 12c Database changes
    • In-memory Database
    • Multi-tenant architecture (container/pluggable databases)
    • Improved optimization
    • Adaptive Execution Plans
    • Expanded maximum size for VARCHAR2, NVARCHAR2, and RAW columns
      • How to use 32K fields
      • Setup requirements
      • What is the Oracle Database Cloud?
  • SQL Developer 4.0 support for Oracle 12c

            Exercise: Explore Available Sample Tables

SELECT improvements

  • Top-N queries (fetch by row or by percentage)
  • Pagination (offset)
  • Performance implications of Top-N and Pagination

            Exercise: Using Top-N and Pagination

Pattern Matching using Regular Expressions


            Exercise: Exploring the Power of Patterns

Outer Join Improvements

  • Expansion of traditional Oracle (+) operator
  • New capabilities provided by CROSS_APPLY and OUTER_APPLY
  • LATERAL inline views

            Exercise: Improving Join Capabilities

Table Definition Improvements

  • Identity Columns: GENERATED AS IDENTITY
  • Column Default using Sequence

            Exercise: Identity Columns and Default Sequences

Enhanced Default Columns

            Computer Exercise: Expanding Column Default Capabilities

Invisible Columns

  • Why would you use Invisible Columns?
  • Maintenance implications of Invisible Columns
  • Multiple Index capability

            Exercise: Using Invisible Columns

Session-Level Sequences

  • Uses of Session-Level Sequences

            Exercise: Sequences at the Session Level

Temporal Validity

  • PERIOD clause in table definition
  • Temporal Validity and Flashback Queries

            Exercise: Working wth Data Periods


  • Understanding how PL/SQL and SQL work together
  • Performance Implications of PL/SQL in WITH and PRAGMA UDF

            Exercise: Improving PL/SQL

Review of Oracle 11g PL/SQL Result Cache

  • Invoker’s Rights Improvement in Oracle 12c PL/SQL Result Cache
  • Understanding how to use PL/SQL Result Cache

            Exercise: Working with PL/SQL Result Cache

JDBC support for PL/SQL types and Implicit Result Sets

  • PL/SQL “white list”

DML Enhancements

  • Online DML locking improved
  • Truncate CASCADE
  • DDL Logging
  • View Expansion

            Exercise: How DML Improvements Work


EBR Improvements

  • Public Synonyms
  • Materialized Views and Types
  • Virtual Columns

            Demonstration: Working with EBR

SkillBuilders Sample Video