Los forms

Forms - An Overview of

Oracle Form Builder v.6.0

1

Agenda

What Is Oracle Form Builder?

Forms Concepts - What is a Form?

The Forms Application

References

2

What Is OracleForm Builder?

• Component of Oracle Developer/2000

– Forms

– Reports

– Graphics

• Application builder

• Event-driven applications

3

Forms - The Basic Idea

• Are used to createapplications to enter, access,

change, or delete data from an Oracle database in an

online, form-based environment.

• Forms provides many objects for developing an

effective applicationmodule.

• Coupled with the concept of user extensibility, Forms

can be used to serve virtually every online need in an

Oracle database environment.

4

Forms Concepts The Big PictureUser actions

Internal events

Triggers

and/or

default processes

Application

State

Database

5

Forms Concepts

• Events

• Processes

• Triggers

6

Forms Concepts

•Events

– Things that happen

– External Events

• User Interaction; Mouse, Keyboard, Menu

– Internal Events

• Timers

• Processing steps for which triggers can be set

– InitiateProcesses

• No Events? No Processing!

7

Forms Concepts

• Processes

– Pre-programmed default behaviour

– What Forms DOES, for example;

•

•

•

•

•

NavigationTransaction Processing

Validation

Query Processing

Master-Detail coordination

– Series of Internal Events

8

Forms Concepts

• Triggers

– Fired when Internal/External events occur

–Replace, supplement or initiate default processing

– Initiate “External” events, to make Forms behave

as if user performed action

• E.g. Simulate User key-press

9

Triggers

• Trigger– Forms trigger

– Database trigger

10

Triggers

• Forms Trigger

– Fires in response to Forms Events

• Database Trigger

– Fires in response to Database Events

• THESE ARE...