Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle 10g Differences for Developers

Recommended Duration:
1-3 Days
Version
Oracle 10g. Course is normally 2 days with labs, 1 day without. An additional day may be added to more-completely cover Oracle object features. Course optionally covers major Oracle9i and/or Oracle8i features.
Benefits
Participants will be introduced to the new and improved features of 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 Oracle10g.
Prerequisites
Experienced Oracle application developers and designers who will be using Oracle10g.
Major Topics
  • New SQL statements
  • 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 improvements
  • Model clause
  • Recycle bin
  • Enhanced Merge
  • HTML DB
  • Optional Oracle9i topics: ANSI/ ISO Join options, CASE statement, Outer join improvements, XML support, External tables
  • MERGE, Object improvements, and expanded Java capabilities
  • Optional Oracle8i topics: Large Objects (CLOB, BLOB, BFILE), INSTEAD OF, DDL AND Database Event Triggers, Function-based Indexes, Cube, Rollup, Analytic Functions, Materialized Views
Exercises
There are twelve regular hands-on computer exercises and several optional exercises.