On-line training course catalogue

Oracle9i: Advanced PL/SQL

Type of course: Classroom

Course details

Fee	£1260
Days	3
Course code	ORAPLS

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

During this five-day instructor-led course, students will learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of packages, cursors, extended interface methods, and advanced object types, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, email interface and fine-grained access are covered.

Prerequisites

Before attending this course, students must have completed:

• Oracle9i: Program with PL/SQL (ORPPLS)
• Introduction to Oracle9i: SQL (ORSQLINT)

Delegates will learn how to

• 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

Outline

• Using function optimisation hints effectively.
• Writing programs with purity features.
• Determining and using the invoker rights model.
• Using autonomous transactions.
• Creating standards for error handling and constants.
• Creating wrappers to protect the intellectual property of a vendor.
• Writing code to interface with external C applications and the operating system.
• Executing Java routines from Pl/SQL.
• Understanding objects in programming.
• Writing code to interface with nested tables and VARRYs.
• Creating PL/SQL code effectively to maximise performance.
• Accessing and setting session level settings programmatically.
• Sending E-mail programmatically.
• Defining, writing, and running a PL/SQL server page.
• Describing the features of fine-grained access control.
• Showing how fine-grained access control works.
• Implementing fine-grained access control