back to Course Categories | back | print
Oracle10g New Features for Developers (migrating from 9i)          

Duration: 3 days

Description 
This course will take a comprehensive look at the new features in Oracle10g for developers. These new features will add significant functionality to Oracle based applications. Topics will include the new SQL features, enhancements to SQL*Plus, new Java features and enhancements to Oracle development environments.

Topics

  • SQLAccess Advisor
  • Single-set aggregates in DML returning clause
  • Upsert with SQL Interrow calculations
  • Single set aggregates in DML returning clause
  • Materialize view tuning API
  • SQL interrow calculations
  • Improvements to collections
  • Enhanced CONNECT BY support
  • Oracle Regular Expressions
  • Row timestamp
  • SQL regular
  • Enhanced collections
  • Enhanced CONNECT BY support
  • Grouped table outer join
  • Enhanced MERGE functionality
  • Remote stored functions in SELECTs
  • Grouped table outer join
  • Increased number of aggregates per query
  • Enhancements to SQL*Loader
  • ETL enhancements
  • Improvements to partitioning
  • Enhancements to virtual private databases
  • Improvements to DDL locking
  • Enhancements to application tuning
  • New optimizer hints
  • Improvements in the CBO
  • Direct path support for ROWID, VARRAY and XML
  • Enhancements to SQL*Plus
  • Session configurations
  • Enhancements to DESCRIBE command
  • SPOOL command improvements
  • Recycle bin
  • Enhancements to iSQL*Plus commands
  • Input prompting
  • Enhancements to auditing
  • Improvements to Fine-Grained Auditing
  • Enhancements to external tables
  • Enhancements to collections
  • Enhanced table functions
  • SQL support for analytical applications
  • VPD support for parallel query
  • VPD static and dynamic policies
  • Column level VPD

Prerequisites

  • Strong Oracle9i development experience is required. Experience with PL/SQL, SQL*Plus, JDeveloper, XML and an understanding of J2EE is strongly recommended.


 
 
 

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