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.