Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle 12c New Features for Developers

Recommended Duration:
1-2 Days
Version
Oracle 12c R2. Course is normally 2 days with labs, 1 day without. Course optionally covers major Oracle 12c R1, 11g, 10g, and/or earlier Oracle features (adds time to course).
Benefits
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.
Audience
Experienced application developers and designers who will be using Oracle12c.
Prerequisites
Prior knowledge of Oracle SQL is useful but not required.
Major Topics
  • Oracle 12c Overview
  • Oracle 12c Database changes
  • Extended (128 Byte) Names
  • Expanded Maximum VARCHAR2
  • Top-N queries (FETCH)
  • Query pagination (OFFSET)
  • Pattern Matching (MATCH_RECOGNIZE)
  • Oracle Outer-Join Operator (+) Improvements
  • CROSS_APPLY and OUTER_APPLY
  • LATERAL inline views
  • Identity Columns
  • Default using Sequence and NULL
  • COLLATE (Binary and Accent)
  • Invisible Columns
  • Session-Level Sequences
  • Temporal Validity (PERIOD)
  • PL/SQL in SELECT WITH
  • PRAGMA UDF
  • Invoker’s Rights for PL/SQL Result Cache
  • Online DML-DDL locking improvements
  • Truncate CASCADE
  • View Expansion
  • JSON in the database
  • EBR Improvements
Exercises
There are twelve regular hands-on computer exercises and one optional exercise.