back to Course Categories | back | print
Oracle9iR2 New Features for Developers          

Duration: 3 days

Description 
This course will give Oracle8i developers a comprehensive overview of the new features in Oracle9i. Database enhancements will be discussed from the perspective of the application developer. Students will learn the new feature/functionality of SQL and PL/SQL changes, changes in the Java and XML functionality, globalization, object-oriented enhancements, data warehousing, user security and performance considerations in the Oracle9i database.

Topics

  • New globalization and Unicode features
  • New CROSS, NATURAL, INNER and OUTER join syntax
  • New data warehouse features
  • New view constraints
  • MERGE statements
  • FOR UPDATE WAIT statement
  • Grouping sets
  • New built-in SQL functions
  • PL/SQL enhancements
  • Analytical functions
  • Table enhancements
  • Multiple table inserts
  • Default column value changes
  • CBO enhancements
  • Enhancements to object-relational features
  • Multiple block sizes
  • Multiple block sizes
  • Enhanced security features
  • New Java and XML features
  • Enhancements to Standby databases
  • Automated consumer Group switching
  • Global index management
  • Extensions to Advanced Queuing
  • Data warehouse enhancements
  • CASE expressions
  • Cursor subqueries
  • List partitioning
  • New schema objects
  • Using External tables

Prerequisites

  • Strong Oracle8i development experience


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design