Oracle Fusion Middleware Build Applications with Oracle Forms
5 days training event
6100-3042
This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training teaches you how to use Oracle Forms Builder 11g. Learn how to rapidly build scalable, high-performance applications for the Web.
Learn To
This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training explores building Oracle Forms Builder 11g. Expert instructors will teach you how to create high-performance applications for the Web that are also scalable.
Use Oracle Forms Builder 11g.
Enhance applications with various GUI controls.
Add functionality to applications by writing triggers.
Use the Forms Debugger to troubleshoot applications.
Validate user input and display meaningful error messages.
Use WebUtil to interact with client computers.
Validate user input, control navigation and display meaningful messages to users.
Use WebUtil to interact with the client machine and pass values from one form to another.
Replace or supplement default transaction processing.
Audience
Application Developers
Forms Developer
Forms Developer
Developer
Support Engineer
Support Engineer
Technical Consultant
PL/SQL Developer
Course Objectives
Link one form module to another
Create form modules, including components for database interaction and GUI controls
Display form modules in multiple windows and use a variety of layout styles
Test form modules in a Web browser
Debug form modules in a 3-tier environment
Implement triggers to enhance form functionality
Reuse objects and code
Course Topics
Running a Forms Application
Using the Modes of Operation
Identifying the Data Elements
Querying Data
Navigating a Forms Application
Displaying Errors
Inserting, Updating, and Deleting Records
Running a Form
Saving Changes
Working in the Forms Builder Environment
Defining Environment Variables
Customizing Your Forms Builder Session
Forms Builder Module Object Hierarchy
Forms Builder Components
Forms Builder Key Features
Forms Executables and Module Types
Navigating the Forms Builder Interface
Testing a Form with the Run Form Button
Creating a Basic Form Module
Using Template Forms
Saving and Compiling a Form Module
Deploying a Form Module
Creating a New Form Module
Producing Documentation
Module Types and Storage Formats
Creating a New Data Bock
Creating a Master-Detail Form
Creating Data Blocks with Relationships
Modifying the Structure of a Data Block
Modifying the Layout of a Data Block
Running a Master-Detail Form Module
Working Data Blocks and Frames
Controlling Frame Properties
Displaying Multiple Property Palettes
Setting Properties on Multiple Objects
Managing Object Properties
Controlling the Behavior and Appearance of Data Blocks
Copying Properties
Creating Control Blocks
Creating Visual Attributes
Working with Text Items
Altering the Navigational Behavior of a Text Item
Modifying the Appearance of a Text Item
Displaying Helpful Messages
Enhancing the Relationship between Text Item and Database
Adding Functionality to a Text Item
Creating a Text Item
Controlling the Data of a Text Item
Creating LOVs and Editors
Defining an Editor
Creating an LOV Manually
LOV Column Mapping
Setting LOV Properties
Setting Editor Properties
Associating an Editor with a Text Item
Using the LOV Wizard to Create an LOV
LOVs and Record Groups
Creating Additional Input Items
Creating a Radio Group
Input Items Overview
Creating a Check Box
Creating a List Item
Creating Noninput Items
Creating a Display Item
Creating a Calculated Item
Creating a Bean Area Item
Creating a Push Button
Creating an Image Item
Noninput Items Overview
Creating a Hierarchical Tree Item
Creating Windows and Content Canvases
Displaying a Form Module on Multiple Layouts
Creating a New Window
Creating a New Content Canvas
Displaying a Form Module in Multiple Windows
Working with Other Canvas Types
Creating a Stacked Canvas
Creating a Toolbar
Overview of Canvas Types
Creating a Tab Canvas
Producing and Debugging Triggers
Using Variables in Triggers
Using the Database Trigger Editor
Using the Forms Debugger
Trigger Overview
Creating Triggers in Forms Builde
Adding Functionality with Built-in Subprograms
Specifying Execution Hierarchy
PL/SQL Editor Features
Adding Functionality to Items
Interacting with Noninput Items
Coding Item Interaction Triggers
Displaying Run-Time Messages and Alerts
Triggers for Intercepting System Messages
Built-Ins and Handling Errors
Controlling System Messages
Handling Server Errors
Creating and Controlling Alerts
The FORM_TRIGGER_FAILURE Exception
Using Query Triggers
Overriding Default Query Processing
Coding Triggers for Enter-Query Mode
Setting WHERE and ORDER BY clauses and ONETIME_WHERE property
Query Processing Overview
SELECT Statements Issued During Query Processing
Obtaining Query Information at Run Time
Query Array Processing
Writing Query Triggers
Validating User Input
Controlling Validation by Using Triggers
Using Built-ins to Control When Validation Occurs
Tracking Validation Status
Performing Client-Side Validation with PJCs
Controlling Validation by Using Properties
Validation Process
Controlling Navigation
Using Navigation Built-Ins in Triggers
Using Object Properties to Control Navigation
Avoiding the Navigation Trap
Writing Navigation Triggers
Overriding or Supplementing Transaction Processing
Transaction Processing Overview
Using Commit Triggers
Implementing Array DML
DML Statements Issued during Commit Processing
Overriding Default Transaction Processing
Testing the Results of Trigger DML
Getting and Setting the Commit Status
Writing Flexible Code
Copying and Subclassing Objects and Code
Referencing Items Indirectly
Using Built-in Subprograms for Flexible Coding
Using System Variables for Flexible Coding
What is Flexible Code?
Referencing Objects by Internal ID
Sharing Objects and Code
Working with Object Groups
Working with PL/SQL Libraries
Benefits of Reusable Objects and Code
Copying and Subclassing Objects and Code
Working with SmartClasses
Working with Object Libraries
Reusing PL/SQL
Working with Property Classes
Using WebUtil to Interact with the Client
Benefits of WebUtil
Integrating WebUtil into a Form
Interacting with the Client
Introducing Multiple Form Applications
Defining Multiple Form Functionality
Sharing Data among Modules
Multiple Form Applications Overview
Starting Another Form Module
TRAINING LOCATIONS
أماكن ومقرات التدريب حول العالم
Dubai
Kuala Lumpur
Tunis
Istanbul
Amman
Sharm El Sheikh
Ottawa
Paris
Lagos
Harare
Kampala
Casablanca