Oracle8i New and Advanced Features For Developers

This 5-day course introduces the new and advanced features for Oracle developers.

Target audience

This course has been developed for senior Oracle developers. Students should have attended the following courses or have equivalent knowledge and experience:

• Introduction To Oracle SQL & PL/SQL
  • Introduction To Oracle Advanced SQL & SQL*Plus
  • Oracle Database Architecture & Administration

Course content

Partitioned tables and indexes

Advanced queuing

Advanced index

Advanced table management features

Database migration

Advanced program units

Large objects (LOBS)

Manipulating large objects (LOBS)

Object database features

Collections

Enhancing groups with ROLLUP and CUBE

Using the database loader Using the loader • LOAD1.CTL Control File • Understanding the loader process • Control file options • Direct path loads • OEM data manager, load

Managing physical storage of objects About physical storage • Storage specification and performance parameters • Table physical storage • Create table with Physical Storage Format • Finding chained rows • Index physical storage

Managing clusters Understanding clusters • Creating a cluster • Data Dictionary, USER_CLUSTERS • Dropping a cluster

National Language Support (NLS)

Invoking external procedures About external procedures • Registering with the database • Calling the external procedure

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today