Oracle SQL and PL/SQL : 11g New Features (1 day)

Audience: An ideal course for anyone who wants to learn the new features of Oracle 10g SQL and PL/SQL.
Pre-requisites: Following are the suggested pre-requisites for this course.

Course content:

Language Functionality Enhancements

Performance Enhancements

PL/SQL Language Enhancements

Trigger Enhancements

SecureFile LOBs

PIVOT and UNPIVOT Clauses of the SELECT Statement

Edition-Based Redefinition

SQL Tuning

Profiling PL/SQL Applications