AUDIENCE:   Developers on existing platforms wishing to take on the new features offered by Oracle 10G. PREREQUISITES:   Delegates should be familiar with Oracle SQL and PL/SQL development environments at a previous release level of Oracle. DURATION:   2 days. Hands on. OBJECTIVES:   The course is intended for Oracle development specialists who need to familiarise themselves with the new development features embodied in the ORACLE 10G database. The course covers a wide range of topics showing the main changes in the SQL command set and in PL/SQL techniques used by developers. COURSE CONTENT:   SQL new features New operators: cross join, natural join, using, on Outer join operators Case expression enhancements Constraint enhancements New SQL functionality New datatypes PL/SQL new features The common PL/SQL parser Case statement Seamless support for LOBS Object enhancements New optimizer and stats gathering options Native dynamic SQL enhancements Review of new PL/SQL packages XML additions Data management LOBs IOT Skip scanning of Indexes Redefining tables online Bitmap join indexes Identifying unused indexes List partitioning External tables Materialised views Explain query rewrite