Oracle 10g Differences for Developers

Course Number:  584-JK
Recommended Duration:  1-3 days

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

Course Overview
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 10g and its features.  Expanded coverage of object features will take an additional (third) day.  Course is normally 2 days with labs, 1 day without labs.  Course optionally covers major Oracle9i and/or Oracle8i features.

Objectives
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.

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

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