Сhat now
Training Center MUKКурсыOracleMiddlewareOracle Fusion Middleware 11g: Build Applications with Oracle Forms

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Course code
OFM11gBA
Duration
5 Days, 40 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview

Course overview

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.

Objectives

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
Prerequisites

Suggested Prerequisite

  • Experience with SQL and PL/SQL basics
  • Experience in advanced SQL & PL/SQL

Audience

  • Application Developers
  • Forms Developer
  • Developer
  • Support Engineer
  • Technical Consultant
  • PL/SQL Developer
Course Outline

Course Topics

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. Creating Additional Input Items

  • Creating a Radio Group
  • Input Items Overview
  • Creating a Check Box
  • Creating a List Item

9. 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

10. 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

11. Working with Other Canvas Types

  • Creating a Stacked Canvas
  • Creating a Toolbar
  • Overview of Canvas Types
  • Creating a Tab Canvas

12. 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

13. Adding Functionality to Items

  • Interacting with Noninput Items
  • Coding Item Interaction Triggers

14. 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

15. 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

16. 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

17. Controlling Navigation

  • Using Navigation Built-Ins in Triggers
  • Using Object Properties to Control Navigation
  • Avoiding the Navigation Trap
  • Writing Navigation Triggers

18. 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

19. 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

20. 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

21. Using WebUtil to Interact with the Client

  • Benefits of WebUtil
  • Integrating WebUtil into a Form
  • Interacting with the Client

22. Introducing Multiple Form Applications

  • Defining Multiple Form Functionality
  • Sharing Data among Modules
  • Multiple Form Applications Overview
  • Starting Another Form Module
Request the training
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Course code:
OFM11gBA
Duration:
5 Days, 40 Acad. Hours
Apply
Сhat now
Свяжитесь со мной
Сhat now
Отправить заявку
Registration for the webinar
Отправить заявку
Your application has been received! We will contact you soon.