Oracle Training : Develop Oracle9i PL/SQL Program Units

Develop Oracle9i PL/SQL Program Units

Oracle Training Overview

An essential component of client/server application development is the creation of database server-side program units. This course discusses the subjects of database triggers and stored procedures. Advanced topics such as using system-supplied packages, programming for superior performance, object oriented encapsulation of logic into packages and many others are discussed in detail.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL
The course Introduction To Oracle9i Advanced SQL
The course Introduction To Oracle9i PL/SQL Language

Suggested Next Courses

The course Oracle 9i New & Advanced Features For Developers or�
The course Oracle 9iDS Forms I: Build Internet Applications

Oracle Training Audience

Oracle developers and database administrators

Oracle Training Objectives

Build comprehensive database triggers
Build new Oracle9i system triggers
Developer stored procedures and functions
Encapsulate program units into packages
Use Oracle Procedure Builder for debugging and code development

Oracle Training Course duration

3 Days

Oracle Training Course outline

UNDERSTANDING THE TUNING ISSUES

TKPROF & AUTOTRACE

USING THE STATSPACK UTILITY

SETTING SNAMPSHOT LEVELS & SQL THRESHOLDS
MAINTAINING THE STATISTICS PERFORMANCE TABLES

EXPLOITING & MANAGING CURSOR SHARING

BIND VARIABLES & CURSOR PEEKING
USING THE CURSOR_SHARING PARAMETER

USING CURSOR VARIABLES

USING SYS_REFCURSOR

INVOKING EXTERNAL PROCEDURES

REGISTERING WITH THE DATABASE
ORACLE NET CONFIGURATION

ADVANCED PROGRAM UNITS

USING INVOKER RIGHTS
NATIVE DYNAMIC SQL
AUTONOMOUS TRANSACTIONS

USING COLLECTIONS

BULK BIND USING COLLECTIONS
COLLECTION METHODS

PL/SQL TUNING WITH DBMS_PROFILER()

INSTALLING DBMS_PROFILER()
USING DBMS_PROFILER() TO MANAGE RUNS

EVALUATING THE PL/SQL PROFILER DATA

USER QUERIES OF THE CROSS RUN TABLES
SYSTEM-SUPPLIED CROSS RUN TABLES QUERIES

PL/SQL TUNING TECHNIQUES

USING NOCOPY FOR PARAMETERS
USING THE RETURNING CLAUSE
CHOOSING THE OPTIMUM DATATYPE
USEFUL PL/SQL CODING TECHNIQUES

PL/SQL DEBUGGING WITH DBMS_TRACE()

INSTALLING DBMS_TRACE()
USING DBMS_TRACE() TO MANAGE RUNS

EXAMINING THE PLSQL_TRACE_ ... TABLES