Oracle 10G New Features for Developers
Course
In Bath
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
Start date
About this course
Delegates should be familiar with Oracle SQL and PL/SQL development environments at a previous release level of Oracle.
Reviews
Course programme
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