Concentrika poppy

About us

Oracle 9i new features for developers

 

About the course

The course is intended for Oracle development specialists who need to familiarize themselves with the new development features embodied in the ORACLE 9i database. The course covers a wide range of topics showing the main changes in he SQL command set and in PL/SQL techniques used by developers. Some of the new features you may be interested in relate to data warehousing, resilience and continuity, performance and web/XML enablement.


Pre-requisites
Delegates should be familiar with Oracle SQL and PL/SQL development environments from a previous version. If you have been experimenting with 9i development features for some time, you might consider our on-site consultancy services more suitable for your needs.


Attendees
Developers on existing platforms wishing to take on the new features offered by Oracle 9i.

Duration

2 days.

1. SQL new features New operators: cross join, natural join, using, on
Outer join operators
Case expression enhancements
Constraint enhancements
New SQL functionality		  
2. PL/SQL new features Summary of new PL/SQL features
The common PL/SQL parser
PL/SQL improvements
Cursor sharing
Select for update WAIT
Inserting PL/SQL record(s) into a table
Querying data into collections of records
Associative arrays (index by tables)
Table functions
Case statement
Native compiled PL/SQL
Review of new PL/SQL packages
Review of XML markup features
after suspend event trigger		  
3. Data management LOBs
Bitmap indexes on IOTs
Bitmap join indexes
Skip scanning of indexes
Redefining tables online
Identifying unused indexes
List partitioning
External tables
Multiple inserts
Materialised views
Explain query rewrite
DBMS_METADATA		  
     

 

 

Courses
schedule
Contact us