• Technical Support Professionals
• Application Developers

Required Prerequisites:

• Develop PL/SQL Program Units
• Introduction to Oracle for Experienced SQL Users
• Introduction to Oracle: SQL and PL/SQL

Suggested Prerequisites:

• Extended Data Retrieval with SQL

Course Objectives:

• Display form modules in multiple windows and use a variety of layout styles
• Implement triggers to enhance functionality to interact with GUI controls
• Create form modules, including components for database interaction and GUI controls
• Communicate with users
• Supplement validation
• Control navigation
• Modify default transaction processing
• Reuse objects and code
• Link one form module to another

Introduction to Oracle Developer

• Features and benefits of Oracle Developer
• Oracle Developer components
• Navigating around the Oracle Developer interface
• Using the on-line help facilities
• The course application

Running a Forms Builder Application

• The runtime environment
• Navigating a forms application
• Retrieving both restricted and unrestricted data from the database into a forms application
• Identifying the two modes of operation
• Inserting, updating and deleting records
• Displaying database errors

Working in the Form Builder Environment

• Identifying the main Forms executables
• Identifying the main components of Form Builder
• Identifying the main objects in a form

Creating a Basic Form Module

• Creating a form module
• Creating a data block
• Saving and running a form module
• Identifying form file formats and their characteristics
• Creating data blocks with relationships
• Running a master-detail form module

Working with Data Blocks and Frames

• Managing object properties
• Controlling the behavior and appearance of data blocks
• Creating data blocks that do not directly correspond to database tables
• Deleting redundant data blocks and their components

Working with Text Items

• Describing text items
• Creating a text item
• Modifying the appearance of a text item
• Controlling the data in a text item
• Altering the navigational behavior of a text item
• Enhancing the relationship between the text item and the database
• Adding functionality to a text item
• Including helpful messages

Creating LOVs and Editors

• Describing LOVs and editors
• Designing, creating, and associating LOVs with text items
• Creating an LOV using the LOV Wizard
• Creating editors and associating them with text items

Creating additional input items

• Identifying the item types that allow input
• Creating a check box
• Creating a list item
• Creating a radio group

Creating non-input items

• Identifying item types that do not allow input
• Creating a display item
• Creating an image item
• Creating a sound item
• Creating a button
• Including tooltips
• Creating a calculated field
• Including a Tree View Control

Creating Windows and Content Canvases

• Describing the relationship between windows and content canvas-views
• Displaying a form module in multiple windows
• Displaying a form module on multiple layouts

Working with Other Canvas-Views

• Describing the different types of canvas-view
• Identifying the appropriate canvas-view type for different scenarios
• Creating an overlay effect on the interface
• Creating a toolbar
• Creating a tabbed interface

Introduction to Triggers

• Identifying the different trigger categories.
• Planning the type and scope of triggers in a form
• Describing the properties that affect a trigger�s behavior

Producing Triggers

• Writing trigger code
• Explaining the use of built-in subprograms in Oracle Developer applications
• Identifying the When-Button-Pressed trigger and knowing when to use it
• Identifying the When-Window-Closed trigger and knowing and knowing when to use it
• Debugging Triggers and Program Units

Adding Functionality to Items

• Supplementing the functionality of input items using triggers
• Supplementing the functionality of non-input items using triggers
• Handling errors using built-in subprograms

Runform Messages and Alerts

• Describing the default messaging behavior of a form
• Identifying the different types of forms messages
• Controlling system messages
• Creating and controlling alerts

Query Triggers

• Explaining the processes involved in querying a data block
• Identifying where triggers can be coded to control the query process
• Writing triggers that screen query conditions
• Controlling trigger action based upon the form�s query status

Validation

• The effects of the validation unit upon a form
• Employing additional forms features for validation
• Controlling validation using triggers

Navigation

• Distinguishing between internal and external navigation
• Describing and using the navigation triggers
• Writing navigation in triggers

Transaction Processing

• Explaining the process used by Oracle Developer to apply users� changes to the database
• Describing the commit sequence of events
• Allocating sequence numbers to records as they are applied to tables

Writing Flexible Code

• Defining flexible code
• The advantages of using system variables
• Identifying built-in subprograms that assist flexible coding
• Referencing objects by internal ID

• Oracle Developer Release 6: Build Forms II

• Oracle Developer Release 6: Build Forms II
• Oracle Developer Release 6: Build Reports
• Form Builder: Forms Fundamentals
• Form Builder: Enhancing the User Interface
• Form Builder: Writing and Debugging Code
• Form Builder: Managing Module Types
• Form Builder: Handling Multiple Object Relationships
• Form Builder: Including Reuseable Oracle Components