Home About Courses Schedule Services Webinars Contact Search

Oracle 12c New Features for Developers

SEE SCHEDULE

Duration: 2 Days

Method: Instructor led, Hands-on Workshops

Price: $1200.00

Course Code: OR5720



View Related Video

Audience

Oracle Developers and End Users.

Description

Try Oracle 12c’s new features for SQL and PL/SQL and their related features here first. Through hands-on exercises, Oracle Developers and End Users can find out which features might provide the most benefits and learn how to properly implement and take advantage of them.

Prerequisites

Some Oracle SQL experience or knowledge

Topics

  1. Deprecated and Desupported Features
  2. SQL Enhancements
    • Top-n Query
    • Concurrent UNION and/or UNION ALL statements
    • Enhancements to the Oracle Left Outer Join Syntax
    • Row Pattern Matching
    • Cascading Truncate Statement
    • WITH Clause New Features
  3. PL/SQL Enhancements
    • PL/SQL Functions with a WITH clause
    • PL/SQL related Security Changes
    • PL/SQL Subprogram White Lists
  4. Sequence-related New Features
    • Default Values for Columns Based on Sequences
  5. Invisible Columns
  6. Identity Columns
  7. Oracle Utilities Enhancements and New Features
    • Data Pump
    • SQL Loader
    • External Tables
    • Online Operations
  8. Performance Enhancements and New Features
    • Adaptive Query Optimization
  9. Schema and Data Changes
  10. Table and Index New Features
  11. Miscellaneous New Features and Enhancements