Oracle Training : Oracle Developer 6i Form Triggers & Objects

Oracle Developer 6i Form Triggers & Objects

Oracle Training Overview

This course builds upon the introductory topics of the Oracle Developer 6i Form Builder course to allow developers to customize applications using complex PL/SQL triggers and object oriented programming techniques. Topics include mouse awareness, writing internal timers, building reusable objects and using reusable object libraries, incorporating PL/SQL libraries and accessing built-in program units.

Completion

Customize complex client/server form applications
Build reusable modules for rapid productivity
Develop and debug complex triggers and program units
Control presentation with windows, canvases and dialog boxes
Building specialty stored procedure data blocks

Prerequisites

Introduction To Oracle8i SQL& SQL*Plus
Introduction To Oracle8i Advanced SQL & SQL*Plus
Introduction To Oracle8i PL/SQL Language
Develop Oracle8i PL/SQL Program Units
Oracle Developer 6i Form Builder

Audience

Oracle client/server and web developers

Course duration

5 Days

Oracle Training Course outline

VALIDATION TRIGGERS

INTRODUCING BUILT-INS USING ALERTS

Form Object Built-Ins
Form Processing Built-Ins
Menu Module Built-Ins
Using Object Ids
Setting Object Properties
Alert Built-Ins

ITEM BUILT-INS

Item Built-Ins (General)
Item Built-Ins (Navigation)
Item Built-Ins (GUI Widgets)
Item Built-Ins (Images)
Item Built-Ins (Sound)
Item Built-Ins (Get and Set Properties)
Radio Button Built-Ins (Get and Set Properties)
GET_FILE_NAME

BUILT-INS FOR OTHER FUNCTIONAL OBJECTS

Block Built-ins
Record Built-Ins
LOV Built-Ins
Editor Built-Ins
Application Built-Ins
Form Module Built-Ins
Form Control Built-Ins
Menu Built-Ins
Relation Built-Ins
More About Restricted Built-Ins
Which Built-Ins Are Usually Restricted?
Triggers Which Permit Restricted Built-Ins
Restricted Built-Ins Table
Triggers That Call Restricted Built-Ins Table

SYSTEM & GLOBAL VARIABLES

Using SYSTEM Variables
Using Global Variables

INTERMEDIATE-LEVEL TRIGGERS & BUILT-INS

User Action Triggers
Navigational Triggers
Query Triggers & Built-Ins
Block Processing Triggers
Key Triggers & Built-Ins
KEY- Triggers Table

WINDOW, CANVAS & ERROR CUSTOMIZATION

Window Built-Ins
Window Triggers
Canvas Built-Ins
Programming Tab Pages
WHEN-TAB-PAGE-CHANGED Trigger
Custom Message & Error Processing

ADVANCED FORMS CUSTOMIZATION

What Are Timers?
About Using WHEN-TIMER-EXPIRED
Timer Built-Ins
Record Groups and Dynamic Lists
Dynamically Alter List Built-Ins
Get List Properties Built-Ins
Calling Other Modules
Parameter Lists

MOUSE AWARENESS

Mouse Events
Mouse 'Click' Triggers
Mouse 'Move' Triggers
Mouse Awareness System Variables
Implementing Drag-And-Drop

OBJECT ORIENTATION

Inheritance With Property Classes
Create A Property Class
Inheriting A Property Class
About Subclass Symbols
Rules About Inheritance
Inheritance With Objects
Building Components With Object Groups
About Object Libraries
Object Library With Tab Categories
SmartClass

INTEGRATING SERVER-SIDE LOGIC

STORED PROCEDURE BLOCKS

Data Block Source
Stored Procedure Data Blocks
Create DEPARTMENT_PACKAGE specification
PL/SQL Package Body Definition

INTRODUCING THE FORMS DEBUGGER