back to Course Categories | back | print
Oracle10g New Features One Day Workshop for Developers          

Duration: 1 day

Description 
This seminar will take a look at the key new features in Oracle10g that will play a key role in Oracle10 development projects. 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 Interow calculations
  • Materialize view tuning API
  • SQL interow calculations
  • Improvements to collections
  • Enhanced CONNECT BY support
  • Oracle Regular Expressions
  • Row timestamp
  • SQL regular
  • 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 suport 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

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