Oracle 10g Forms II: Customize Internet Applications

Course Description

The Objective Of This Course Is To Provide Application Software Developers With The Skills To Build And Customize Advanced Enterprise-Scale Web Applications Using The Oracle10g Forms Product. Major Subject Areas To Be Explored Are: • Building Client-Side Triggers And Program Units To Customize Forms Applications. • Dynamically Controlling Form Objects And Behavior During Runtime. • Taking Advantage Of Built-In Functions And Procedures. • Writing Efficient And Well-Tuned Client-Side Logic. • Integrating Multiple Oracle10g Modules Into Enterprise Applications. • Exploiting Object-Oriented Features To Maximize Reuse Of Components. • Specialized Techniques Such As Hierarchical Trees, Procedure Data Blocks, And Timers. • Integrating Forms Logic With Database Server Objects Into A Cohesive Solution.
5 days
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

Prerequisites For This Course:
• Oracle Database 10g: Introduction To Sql
• Oracle Database 10g: Programming With Pl/Sql
• Oracle10g Forms I: Build Internet Applications

Developing Programs Within Forms

• About Oracle10g Program Development
• Understanding Client-Side Triggers
• Understanding Client-Side Program Units
• Understanding Built-In Subprograms
• Understanding Pl/Sql Libraries

The Pl/Sql Editor

• Understanding Pl/Sql Editor Concepts
• Using The Pl/Sql Editor
• Using The Pl/Sql Editor Productivity Features

The Validation Triggers

• Using The Validation Triggers
• Using When-Validate-Item

Understanding Built-Ins Using Alerts

• Understanding Built-In Concepts
• Categories Of Built-Ins
• Calling Built-In Procedures Vs. Functions
• Using Object Id References
• Referencing Object Properties
• Using The Alert Built-Ins

Using The Item Built-Ins

• Understanding Item Built-Ins
• Using General Item Built-Ins
• Using Navigation Item Built-Ins
• Using Item Built-Ins To Get & Set Properties

Specialty Item Built-Ins

• About Specialty Item Built-Ins
• Using Gui Control Items Built-Ins
• Using Menu Item Built-Ins
• Using Image Item Built-Ins

Using Built-Ins For Other Functional Objects

• About The Functional Object Built-Ins
• Using The Block Built-Ins
• Get_Block_Property() & Set_Block_Property()
• True / False Properties List
• Using The Record Built-Ins
• Using The Lov Built-Ins
• Using The Editor Built-Ins
• Using The Relation Built-Ins
• About Restricted Built-Ins

Using Application & Module Built-Ins

• About The Application & Form Built-Ins
• Using The Application Built-Ins
• Using The Form Built-Ins

Specialized Programming Techniques

• About The Techniques
• Using System Variables
• Using Global Variables
• Using Indirect References

Intermediate-Level Triggers And Built-Ins

• About Intermediate-Level Trigger Categories
• Using End User Action Triggers
• Using Navigational Triggers
• Using Query Triggers & Built-Ins
• Using Block Processing Triggers
• Using Key Triggers & Built-Ins

Dynamic Control Over Visual Objects

• Working With Visual Objects
• Using The Window Built-Ins & Triggers
• Using The Canvas Built-Ins

Error Customization

Advanced Forms Customization

• About Record Groups & Dynamic Lists
• Using Record Groups
• Using Dynamic Lists

Advanced Forms Customization

• About Multiple Modules & Parameter Lists
• Calling Form Module Built-Ins

Object Orientation, Property Classes

• Understanding Object Orientation Concepts
• Obtaining Inheritance With Property Classes

Object Orientation, Building Reusable Components

• About Reusable Components
• Obtaining Inheritance With Objects
• Using Object Groups
• Using Object Libraries

Object Orientation, Writing Reusable Logic

• Understanding Advanced Object Principles
• Object Orientation With Packages
• Object Orientation With Pl/Sql Libraries

Integrating Server-Side Logic

• Accessing Database Server-Side Logic
• Integrating Database Constraints
• Integrating Database Procedures
• Integrating Database Triggers

Building Stored Procedure Data Blocks

• Choosing The Data Block Source
• Implementing Stored Procedure Data Blocks

Hierarchical Trees

• What Are Hierarchical Trees?
• Creating The Hierarchical Tree
• Populating The Tree With Data
• Hierarchical Tree Triggers & System Variables
• Using Ftree() & Hierarchical Tree Built-Ins
• Add_Tree_Data()
• Add_Tree_Node()
• Delete_Tree_Node()
• Get_Tree_Node_Parent()
• Get_Tree_Node_Property()
• Get_Tree_Property()
• Get_Tree_Selection()
• Populate_Group_From_Tree()
• Populate_Tree()
• Set_Tree_Node_Property()
• Set_Tree_Property()
• Set_Tree_Selection()
• Find_Tree_Node()