Home About Courses Schedule Services Webinars Contact Search

Oracle 18c New Features for Developers

SEE SCHEDULE

Duration: 1 day

Method: Instructor led, Hands-on workshops

Price: $600.00

Course Code: OR5850


Audience

Oracle Developers and End Users.

Description

Try Oracle 18c’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 and PL/SQL experience or knowledge.

Topics

  • I. SQL New Features and Enhancements
    • Private Temporary Tables
    • Ability to Create Schema Only Accounts
    • Approximate Top-N Query Processing
    • Non-Persistable Data Types
    • Scalable Sequences
    • SQL*Plus Changes
    • SQL Developer Changes
    • Miscellaneous SQL Changes
    • Deprecated Features
    • Desupported Features
  • II. PL/SQL New Features and Enhancements
    • Non-Persistance Support for Object Types
    • Polymorphic Table Functions
    • PL/SQL Qualified Expressions
    • Miscellaneous PL/SQL Changes
    • Deprecated Features
    • Desupported Features
  • III. SQL, PL/SQL Tuning Changes
    • PL/SQL Hierarchical Profiler (DBMS_HPROF) Enhancements
    • SQL Tuning Advisor Exadata Enhancements
    • New SQL Tuning Set API
    • Concurrent SQL Execution with SQL Performance Analyzer
    • Memoptimized Rowstore
  • IV. Miscellaneous Database Enhancements and Changes