Oracle9i Differences for Developers
- Recommended Duration:
- 1-3 Days
- Version
- Oracle9i. Course optionally covers major Oracle8i features.
- Benefits
- Participants will be introduced to the new and improved features of Oracle9i 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 Oracle8i or Oracle9i.
- Prerequisites
- Experienced Oracle application developers and designers who will be using Oracle9i.
- Major Topics
-
- New Datatypes
- New Functions
- ISO/ANSI Function Additions
- CASE Expressions
- New Join Syntax (INNER, OUTER, FULL, LEFT, RIGHT, NATURAL, CROSS)
- Merge Statement
- External Tables
- Multi-Table Inserts
- Cursor Expressions and Enhancements
- XML Support
- Introduction to Internet File System (IFS)
- Improved Java Support
- PL/SQL Improvements and Native Compile
- Miscellaneous changes in Oracle9i
- Overview of DBA-Oriented Features
- 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 thirteen regular hands-on computer exercises and several optional exercises.