Seer Computing Limited - Site Map

Contents

This intensive hands on training course is broken down into eight sections and includes the following aspects of Oracle 9i:

CASE function in PL/SQL
Extensions to Group by clause
Timestamp Data Type
New Built in Functions Nullif, Coalesce
Merge statements
Multiple table inserts
Utl_file enhancements


Exercises

There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include:

Creation and use of new datatypes
Usage of Merge and Multiple table insert functions
Usage of CASE and other new PL/SQL functions



Course Duration

One day

The Oracle 9i database is the most complete and comprehensive platform for building and deploying internet and enterprise applications.
The 9i database has many new features that offer improved performance, functionality and reliability to developers building applications.
It is essential for Developers to understand these new features in order to take advantage of the full power of 9i.

Pre-Requisite Course(s)
Introduction to SQL
PLSQL I
8i New Features for Developers

Next Course(s)
8i DBA I
9i DBA I