Oracle 11g Differences for Developers
- Recommended Duration:
- 1-2 Days
- Version
- Oracle 11g. Course is normally 2 days with labs, 1 day without. Course optionally covers major Oracle9i and/or Oracle8i features.
- Benefits
- 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.
- Audience
- Experienced application developers and designers who will be using Oracle11g.
- Prerequisites
- Experienced Oracle application developers and designers who will be using Oracle11g.
- Major 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
- Exercises
- There are eight regular hands-on computer exercises and several optional exercises.