Back to Search Results

Training Course Summary:

In this course delegates broaden their application building skills using Oracle Forms Developer, a productive development environment for building enterprise-class Internet database applications. Delegates create multiple-form Internet applications and learn to manage multiple transactions across modules. By adding custom menus, reports, and charts they also learn to enhance their applications. Finally, the course teaches delegates to enhance the user interface for Web-deployed forms using Java Beans.

Pre-Requisites:

Introduction to Oracle: SQL and PL/SQL (SPLI) or Introduction to Oracle for Experienced SQL Users Develop PL/SQL Program Units (DPP) Oracle Forms Developer: Build Internet Applications Part 1(IFM6i) is essential to FM6ii.

Training Course Overview/Content:

Creating a Menu Document
Menu Documents Overview
Creating a Menu Document
Saving and Attaching a Menu Document
Creating Smart Bars
Creating Pop-Up Menus

Managing Menu Documents
Controlling Menu Documents with Built-in Subprograms
Implementing Menu Security with Oracle8i Database Roles

Programming Function Keys
Defining Key Triggers
Writing Key Triggers
Identifying the Characteristics of Key Triggers
Using Key Triggers
Associating Key Triggers with Other Interface Controls

Responding to Mouse Events
Defining Mouse Events
Responding to Mouse Events
Responding to Mouse Button Actions
Identifying Limitations of Mouse Triggers with Web-Deployed Forms

Controlling Windows and Canvases Programmatically
Managing Single Document Interface (SDI) and Multiple Document Interface (MDI) windows with Web-Deployed Forms
Managing Images Within Web-Deployed Forms
Displaying Multiple Windows
Defining Window Interaction Triggers
Manipulating Windows with Built-in Subprograms
Manipulating Canvas Views with Built-in Subprograms
Managing Windows and Multiple Data Blocks
Managing Windows and Large Data Blocks

Defining Data Sources
Defining Data Source Types
Basing a Data Block on a From Clause Query
Basing a Data Block on a Stored Procedure
Returning a REF Cursor
Returning a Table of Records

Working with Oracle8i Objects in Form Builder
Representing Object Types in Oracle Forms Developer
Creating a Data Block Based on an Object Table
Creating a Data Block Based on an Object Table Using REF columns
Populating a REF Column with a List of Values (LOV)

Controlling Data Block Relationships
Defining Relations
Creating a Foreign Key Relation
Creating a REF Relation
Modifying a Relation
Co-ordinating Data Blocks
Defining Co-ordination Properties for Web-Deployed Forms
Defining Characteristics and Principles of Relation-Handling Triggers
Implementing a Co-ordination-Type Toggle
Forcing a Commit Per Master

Building Multiple-Form Applications
Defining Methods of Invoking Addition Form Modules
Opening, Calling, and Closing Form Modules
Navigating Between Web-Deployed Forms
Controlling Open Forms Modules and Called Form Modules
Managing Transaction Processing for Open and Called Forms
Using Form Parameters
Creating and Manipulating Parameter Lists
Passing Data Between Form Modules

Working with Record Groups
Dining and Using Record Groups
Controlling Record Groups with Built-in Subprograms
Defining Query Record Groups Programmatically
Defining Non-Query Record Groups Programmatically
Defining Lists of Values (LOV) Programmatically
Implementing Dynamic List Items
Adding Values to Combo Boxes

Reusable Components
Defining Reusable Components
Using Reusable Components in Web-Deployed Forms
Including the Calendar Object
Including the Picklist Object

Using Java in Web-Deployed Forms
Defining Fonts and Colours for Web-Deployed Forms
Deploying Web Forms with Java Components
Incorporating JavaBeans and Pluggable Java Components (PJC) in Web-Deployed Forms
Exploiting Oracle8i features in Web-Deployed Forms

Using Server Features in Forms
Using Server Functionality
Managing PL/SQL
Recognising Supported PL/SQL8 Features in Oracle Forms Developer
Handling Oracle8i Server Errors
Identifying the Cause of Declarative Constraint Violations
Performing Data Definition Language (DDL) with FORMS_DDL

Applying Timers
Defining Timers
Handling Timer Expiration
Creating, Modifying, and Deleting Timers
Managing Timers in Web-Deployed Forms

Including Charts and Reports
Invoking the Chart Wizard
Including Charts Using the Chart Wizard
Invoking the Report Wizard
Including Reports Using the Report Wizard
Including Reports in Web-Deployed Forms Using Built-in Subprograms



Course Objectives

At the end of the course delegates will understand how to:-

Ensure application security in Oracle8i database roles Implement triggers for function keys, mouse movement, mouse buttons and