Oracle 9i Discoverer administration

Aims and Objectives
Create PL/SQL applications that use Oracle objects.
Implement Oracle9i features to create large, complex and effective applications.
Design PL/SQL packages and program units that execute efficiently.
Write and tune PL/SQL code effectively to maximise performance.
Write code to interface with external applications and the operating system.
Use some of the advanced features of the supplied built-in packages to implement a wide range of functionality.

Target Audiences
This course is targeted towards Database administrators who have experience using PL/SQL.

Prerequisites
Students must have completed:
Oracle9i: Program with PL/SQL.
Introduction to Oracle9i: SQL.

Course Content
Module 1: Using function optimisation hints effectively
Module 2: Writing programs with purity features
Module 3: Determining and using the invoker rights model
Module 4: Using autonomous transactions
Module 5: Creating standards for error handling and constants
Module 6: Creating wrappers to protect the intellectual property of a vendor
Module 7: Writing code to interface with external C applications and the operating system
Module 8: Executing Java routines from Pl/SQL
Module 9: Understanding objects in programming
Module 10: Writing code to interface with nested tables and VARRYs
Module 11: Creating PL/SQL code effectively to maximise performance
Module 12: Accessing and setting session level settings programmatically
Module 13: Sending E-mail programmatically defining, writing and running a PL/SQL server page.
Module 14: Describing the features of fine-grained access control
Module 15: Showing how fine-grained access control works

Implementing fine-grained access control