Oracle 10G New Features for Developers

Course

In Bath

Price on request

Description

  • Type

    Course

  • Location

    Bath

  • Duration

    2 Days

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. Suitable for: Developers on existing platforms wishing to take on the new features offered by Oracle 10G.

Facilities

Location

Start date

Bath (Somerset)
See map
11 Kingsmead Square, BA1 2AB

Start date

On request

About this course

Delegates should be familiar with Oracle SQL and PL/SQL development environments at a previous release level of Oracle.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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

Oracle 10G New Features for Developers

Price on request