Oracle Forms I & II

IN-603

MODULE 1:  Introduction

Topics covered:

  • What is Oracle Forms?
  • Oracle Form Builder Components
  • Application Code Partitioning
  • Exercise: Preparing to Work with Oracle Forms

MODULE 2:  Getting Started

Topics covered:

  • Creating an Oracle Form
  • Running an Oracle Form
  • The Runtime Interface
  • Performing Queries
  • Updating Records
  • Exercise: Creating and Running an Oracle Form

MODULE 3:  The Form Builder Interface

  • The Main Menu
  • The Object Navigator
  • Basic Components of a Form
  • Property Palettes
  • The PL/SQL Editor
  • The Layout Editor
  • Exercise: Using Oracle Form Builder Tools

MODULE 4:  Building a Form

  • Basic Steps in Development
  • Creating a Data Block
  • Customising the Layout
  • Setting Properties For Data Blocks and Items
  • Adding Trigger Code
  • Running the Oracle Form
  • Exercise: Building a Simple Oracle Form
  • Exercise: Building a Master-Detail Oracle Form

MODULE 5:  Triggers

  • What is Navigation?
  • Navigational Triggers
  • Item and Block Validation
  • Commit Form Triggers
  • Query Triggers
  • Trigger Types and Scope
  • Trigger Code
  • Global, System and Bind Variables
  • Handling Errors
  • Exercise: Implementing Navigational Triggers
  • Exercise: Implementing Commit-time Triggers
  • Exercise: Implementing Query Triggers

MODULE 6:  Introducing Standard Built-Ins

  • Unrestricted Built-in Procedures and Functions
  • Restricted Built-in Procedures
  • Calling Built-ins
  • Getting and Setting Properties at Runtime
  • Using Internal Object IDs
  • Error Handling
  • Exercises: Enhancing Oracle Form Applications using Built-ins

MODULE 7:  More Interface Objects

  • Basic Controls – Text and Display Items
  • Iconic Push-buttons
  • Check Boxes and Radio Groups
  • List Items
  • Image Items
  • Alerts
  • Editors
  • Record Groups and LOVs
  • Hierarchical Trees
  • Exercises: Creating Additional Interface Items

MODULE 8:  Program Units

  • Oracle Form Module Program Units
  • PL/SQL Libraries
  • Database Procedures
  • Exercise: Using PL/SQL Libraries
  • Exercise: Using Database Procedures

MODULE 9:  Canvases and Windows

  • Content Canvases
  • Stacked Canvases
  • Toolbar Canvases
  • Tab Canvases
  • Handling Windows
  • Exercise: Generating Canvases and Toolbars
  • Exercise: Handling Multi-Window Applications

MODULE 10:  Re-Using Components

  • Visual Attributes
  • Property Classes
  • Copying Objects
  • Subclassing
  • Object Groups
  • Object Libraries
  • Exercise: Creating and Using a Property Class
  • Exercise: Creating and Using an Object Library

MODULE 11:  Introduction to Calling Other Forms

  • Built-in Procedures
  • Methods for Calling other Oracle Forms
  • Exercise: Calling one Oracle Form from Another

MODULE 12:  Debug Facilities

  • Exercise: Interfacing with an Oracle Report
  • Running in Debug Mode
  • Creating Break Points
  • Monitoring Application Data

MODULE 13:  Oracle Forms Services

  • Overview
  • Oracle Forms Compatibility Issues
  • Architecture and Components of the Oracle Forms Client

MODULE 14:  Getting Started

  • Preparation
  • Default Deployment
  • Using runform.htm for Testing
  • Generating URLs
  • Default Configuration Files
  • Exercise: Test an Oracle Form using runform.htm
  • Exercise: Create a URL to Deploy and Test an Oracle Form

MODULE 15:  Configuring Forms Services

  • The formsweb.cfg Configuration File
  • System and Runform Parameters
  • Forms Applet and HTML Tag Parameters
  • Archive Parameters
  • Creating Application-specific Configurations
  • Renaming and Relocating formsweb.cfg
  • Customising the base HTML Files
  • Exercise: Create Application-specific Configurations
  • Exercise: Create a Custom Configuration File

MODULE 16:  Dealing With Icons and Images

  • Boilerplate and HTML Images
  • Forms Icons and Images
  • Images Loaded at Runtime
  • Other Images
  • SplashScreen, Background and Logo Images
  • Using jar Files
  • Exercise: Deploy a Variety of Icons and Images
  • Exercise: Create and Use a jar File

MODULE 17:  Other Configuration Issues

  • Icons in Form Builder
  • The Environment File default.env
  • The Registry File registry.dat
  • Font Mappings
  • The web.xml and forms90.conf Config Files
  • Notes on Configuring for SSO
  • JInitiator
  • Exercise: Configure registry.dat and default.env
  • Exercise: Configure web.xml and forms90.conf

MODULE 18:  Performance Considerations

  • Built-in Optimisation Features
  • Using and Customising JInitiator
  • Improving Performance
  • Exercise: Implement Features to improve Performance

Forms II

MODULE 1:  An Introduction

  • Notes on Course Content
  • Preparation
  • Exercise: Creating Basic Oracle Forms Applications

MODULE 2:  Mouse and Key Triggers

  • Mouse Triggers
  • Cursor Styles
  • Key Triggers
  • Exercise: Implementing Mouse and Key Triggers

MODULE 3:  Timers

  • Use of Timers
  • Creating and Handling Timers
  • Timer Triggers and Built-ins
  • Exercise: Creating a Clock Timer

MODULE 4:  Record Groups

  • LOVs and Record Groups
  • Record Group Types
  • Creating Run-time Record Groups
  • Built-in Procedures and Functions
  • Record Groups and Lists
  • Exercise: Using Run-time Record Groups

MODULE 5:  Data Block Relationships

  • Relation Object Properties
  • Creating Relationships Manually
  • Procedures and Triggers for Coordination
  • Modifying Default Functionality
  • Exercise: Creating and Modifying a Relation Object

MODULE 6:  Multi-Form Applications

  • Calling Other Forms
  • The OPEN_FORM Procedure
  • The CALL_FORM Procedure
  • The NEW_FORM Procedure
  • Related Built-ins
  • Passing Data between Forms
  • Creating Parameters and Parameter Lists
  • Exercise: Calling Oracle Forms and Passing Parameters

MODULE 7:  Creating Custom Menus

  • Menu Modules, SubMenus and Menu Items
  • The Menu Editor
  • Menu and Menu Item Properties
  • PL/SQL in Menu Modules
  • Menu Item Built-ins
  • Menu Security
  • Menu Parameters
  • Popup Menus
  • Exercise: Generating a Custom Menu

MODULE 8:  Handling Database Objects

  • Object Support and Object Types
  • Object Tables
  • Column Objects
  • Handling REF Columns
  • Exercise: Handling Objects with an Oracle Form

MODULE 9:  Using Other Data Sources

  • Data Source Types
  • Using a FROM Clause Query
  • Using Procedures which return REF Cursors
  • Using Procedures which return PL/SQL Index-By Tables
  • Implementing DML using Packaged Procedures
  • Exercise: Defining and using FROM Clause Query
  • Exercise: Defining and using a Packaged Procedure

MODULE 10:  Using Oracle Database Features

  • Database Functionality
  • Handling PL/SQL Code
  • Handling Database Server Errors
  • Using the FORMS_DDL Package
  • DDL Functionality
  • Exercise: Using the FORMS_DDL Package

MODULE 11:  Reusable Components

  • Reusable Component Definition
  • Oracle-Supplied Components
  • Using Oracle’s Calendar Class Component
  • Notes on Active X Controls
  • JavaBeans and PJCs
  • Exercise: Implementing the Calendar Component
  • Exercise: Implementing Pluggable Java Components

MODULE 12:  Including Charts and Reports

  • Including Charts
  • Oracle Reports Overview
  • Running an Oracle Report
  • Integrating Oracle Reports with Oracle Forms
  • Viewing an Oracle Report
Want To Share This?


Send Whatsapp Message To Us