Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle 11g/10g Differences for Developers

Recommended Duration:
2 Days
Version
Oracle 11g/10g. Course is normally 2 days with labs, 1 day without.
Benefits
Participants will be introduced to the new and improved features of Oracle 11g and Oracle 10g 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/10g.
Prerequisites
Experienced Oracle application developers and designers who will be using Oracle11g and Oracle 10g.
Major Topics
  • Case/accent-insensitive query
  • Regular expressions
  • Expanded LOB storage
  • New data types (BINARY_FLOAT, BINARY_DOUBLE, SDO_GEORASTER)
  • New Statistical functions
  • "Fast" dual
  • Connect changes
  • SQL*Plus and iSQL*Plus
  • Model clause
  • Recycle bin
  • Enhanced Merge
  • HTML DB
  • MERGE, Object improvements, and expanded Java capabilities
  • 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
  • New data types: Simple_integer, Simple_float, and Simple_double
  • New JDBC driver support Java 5/6
  • Pro* and OCI improvements
Exercises
There are nine regular hands-on computer exercises and several optional exercises.