Forms 10g: Level 1

Course Overview

This course is for programmers and developers who need to design applications to access the Oracle database. This course takes delegates though application development in Developer Forms 10G beginning with basic form design and ending up with fully integrated applications rollout. The integrated workshops are designed to mimic a true application building process.

Audience

Programmers and developers who need to design applications to access the Oracle database.

Skills Gained

On completion, delegates will have a good understanding of the Oracle Forms 10G environment and will be able to generate all levels of Forms to access the Oracle database. The course covers the design interface, object navigation and processing, library package integration and external Forms interfaces.

Examinations

A list or description of examinations which will, or can be, taken following completion this course.

Prerequisites

A good knowledge of SQL and PL/SQL, preferably gained through attendance of a suitable course like our Oracle SQL and PL/SQL courses together with some experience of using these products in an everyday role. Knowledge of the GUI environment would be advantageous.

Course Outline

Developer Overview

• Developer Reports
• Developer Forms
• Other Components of Developer Suite
• Application development

Forms Architecture

• Forms initialisation parameter
• Client/Server architecture
• Internet/Intranet architecture

Building our Application

• Creating a master/detail relation
• Changing layout and properties
• Adding a stacked canvas

Event Triggers

• Creating triggers
• Types of triggers
• Program Units
• PL/SQL
• Creating program units
• Input parameters for procedure
• Output parameters for procedures
• I/O parameters for procedures
• Functions in program units
• Local procedures and functions
• Compiling program units

Adding Windows Functionality

• Radio groups
• Check boxes and list items
• Buttons & toolbars
• Visual attributes
• Editors
• Alerts
• Creating application windows
• About popup menus

Record Groups

• Static record groups
• Query record groups
• Dynamic record groups

Lists of Values (LOV)

• Creating an LOV
• Creating a trigger for our LOV

Packages

• Package structure
• Package creation

Built-in Packages

• DDE
• TEXT_IO

Design Concepts - Sharing Objects

• Creating an object group
• Libraries
• Property classes

Menus

• Creating A Menu
• Adding a Menu to a Form

Debug

• How Debug works

Forms Applications

• Workshop Projects
• Deliver Web-based application