Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

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 Oracle 10g, Oracle 9i, and/or Oracle8i features.
(adds time to course)
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
Prior knowledge of Oracle SQL is useful but not required.
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 Functions: REGEXP_COUNT,
    LIST_AGG, NTH_VALUE
  • 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
  • SQL and PL/SQL result caches
  • New JDBC driver support
  • Pro* and OCI improvements
  • Edition-Based Redefinition (EBR)
Exercises
There are eight regular hands-on computer exercises and one optional exercise.