Course Icon ORACLE Training

Oracle Forms - Part II

0800 1337 401

Overview

Designed for programmers and software developers who are already familiar with the basic features of Oracle Forms. This Oracle Forms - Part II course is designed to introduce delegates to the more advanced features of Oracle Forms.

Prerequisites

Attendance on the pre-requisite courses or practical experience in developing basic Oracle Forms applications.

Objectives

To provide the skills needed to design, develop and enhance end-user write Oracle Forms applications which interact with an Oracle Relational Database.

Outline

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: AN INTRODUCTION

  • Notes on Course Content
  • Preparation
  • Exercise: Creating Basic Oracle Forms Applications

Session 2: MOUSE AND KEY TRIGGERS

  • Mouse Triggers
  • Cursor Styles
  • Key Triggers
  • Exercise: Implementing Mouse and Key Triggers

Session 3: TIMERS

  • Use of Timers
  • Creating and Handling Timers
  • Timer Triggers and Built-ins
  • Exercise: Creating a Clock Timer

Session 4: RECORD GROUPS

  • LOVs and Record Groups
  • Record Group Types
  • Creating Run-time Record Groups
  • Built-in Procedures and Functions
  • Record Groups and Lists
  • Exercise: Using Run-time Record Groups

Course Contents - DAY 2

Session 5: DATA BLOCK RELATIONSHIPS

  • Relation Object Properties
  • Creating Relationships Manually
  • Procedures and Triggers for Coordination
  • Modifying Default Functionality
  • Exercise: Creating and Modifying a Relation Object

Session 6: MULTI-FORM APPLICATIONS

  • Calling Other Forms
  • The OPEN_FORM Procedure
  • The CALL_FORM Procedure
  • The NEW_FORM Procedure
  • Related Built-ins
  • Passing Data between Forms
  • Creating Parameters and Parameter Lists
  • Exercise: Calling Oracle Forms and Passing Parameters

Session 7: CREATING CUSTOM MENUS

  • Menu Modules, SubMenus and Menu Items
  • The Menu Editor
  • Menu and Menu Item Properties
  • PL/SQL in Menu Modules
  • Menu Item Built-ins
  • Menu Security
  • Menu Parameters
  • Popup Menus
  • Exercise: Generating a Custom Menu

Session 8: HANDLING DATABASE OBJECTS

  • Object Support and Object Types
  • Object Tables
  • Column Objects
  • Handling REF Columns
  • Exercise: Handling Objects with an Oracle Form

Course Contents - DAY 3

Session 9: USING OTHER DATA SOURCES

  • Data Source Types
  • Using a FROM Clause Query
  • Using Procedures which return REF Cursors
  • Using Procedures which return PL/SQL Index-By Tables
  • Implementing DML using Packaged Procedures
  • Exercise: Defining and using FROM Clause Query
  • Exercise: Defining and using a Packaged Procedure

Session 10: USING ORACLE DATABASE FEATURES

  • Database Functionality
  • Handling PL/SQL Code
  • Handling Database Server Errors
  • Using the FORMS_DDL Package
  • DDL Functionality
  • Exercise: Using the FORMS_DDL Package

Session 11: REUSABLE COMPONENTS

  • Reusable Component Definition
  • Oracle-Supplied Components
  • Using Oracle's Calendar Class Component
  • Notes on Active X Controls
  • JavaBeans and PJCs
  • Exercise: Implementing the Calendar Component
  • Exercise: Implementing Pluggable Java Components

Session 12: INCLUDING CHARTS AND REPORTS

  • Including Charts
  • Oracle Reports Overview
  • Running an Oracle Report
  • Integrating Oracle Reports with Oracle Forms
  • Viewing an Oracle Report
  • Exercise: Interfacing with an Oracle Report
See all of the available Technical Courses