Oracle 11g Differences for Developers

Course Number:  583-JK
Recommended Duration:  1-2 days

Intended Audience
Experienced application developers and designers who will be using Oracle11g.

Course Overview
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 11g and its features.  Course is normally 2 days with labs, 1 day without.  Course optionally covers major Oracle9i and/or Oracle9i features.

Objectives
Participants will be introduced to the new and improved features of Oracle 11g that concern Application Developers. Several exercises involve practice using new items discussed in the class.

Prerequisites
Experienced Oracle application developers and designers who will be using Oracle11g.

Topics

• Oracle 11 overview

• iSqlPlus and SQLPLUSW gone

• Virtual Columns

• Uses for Virtual Columns

• XML Binary XMLTYPE

• Next-Generation LOB Securefile

• SQL Pivot and Unpivot

• New Function REGEXP_COUNT

• New Functions: CUBE_TABLE, XMLCAST, XMLEXISTS, XMLDIFF, XMLPATCH

• PL/SQL compiler enhancements

• PL/SQL enhancements

• Sequence numbers in PL/SQL

• PL/SQL CONTINUE

• PL/SQL Trigger improvements

• CALL syntax has improved

• Simple_integer

• Simple_float

• Simple_double

• New JDBC driver support Java 5 (1.5) & 6

• Pro* and OCI improvements