Oracle Forms11g Expert
Interactive hands-on course help candidates to learn Oracle Forms 11g. Candidate learn how to customize forms through user input items and how to control data access by creating event-related triggers using PL/SQL. The candidates knows the secrets for leveraging the power of Oracle Forms 11g for fast and flexible application development. We give special care to every candidates to complete the hands-on lab exercises on each topic.
Day 01
Introducing Oracle Forms 11g
• Oracle 11g Products
• Oracle Weblogic 11g Architecture Overview
• Benefits and Components of Oracle Developer Suite 11g
• Running a Forms Developer Application
• Working in the Forms Developer Environment
Creating Forms Modules
• Creating a Basic Forms Module
• Creating a Master-Detail Forms Module
• Modifying the Data Block
• Modifying the Layout
Working with Data Blocks and Frames
• Using the Property Palette
• Managing Object Properties
• Creating and Using Visual Attributes
• Controlling the Behavior and Appearance of Data Blocks
• Controlling Frame Properties
• Creating Control Blocks
• Deleting Data Blocks
Working with Input Items
• Creating Text Items
• Controlling the Behavior and Appearance of Text Items
• Creating LOVs
• Defining Editors
• Creating Check Boxes
• Creating List Items
• Creating Radio Groups
Working with Non Input Items
• Creating a Display Item
• Creating an Image Item
• Creating a Push Button
• Creating a Calculated Item
• Creating a Hierarchical Tree Item
• Creating a Bean Area Item
Day 02
Working with Windows and Canvases
• Overview of Windows and Canvases
• Displaying a Forms Module in Multiple Windows
• Creating a New Window
• Displaying a Forms Module on Multiple Layouts
• Creating a New Content Canvas
• Creating a New Stacked Canvas
• Creating a New Toolbar Canvas
• Creating a New Tab Canvas
Producing Triggers
• Grouping Triggers into Categories
• Defining Trigger Components: Type, Code, and Scope
• Specifying Execution Hierarchy
• Using the PL/SQL Editor
• Writing Trigger Code
• Using Variables and Built-ins
• Using the When-Button-Pressed and When-Window-Closed Triggers
Debugging Triggers
• The Debugging Process
• The Debug Console
• Setting Breakpoints
• Debugging Tips
• Running a Form in Debug Mode
• Stepping through Code
Adding Functionality to Items
• Coding Item Interaction Triggers
• Defining Functionality for Check Boxes
• Changing List Items at Run Time
• Displaying LOVs from Buttons
• Populating Image Items
• Populating and Displaying Hierarchical Trees
Run-Time Messages and Alerts
• Built-ins and Handling Errors
• Controlling System Messages
• The FORM_TRIGGER_FAILURE Exception
• Using Triggers to Intercept System Messages
• Creating and Controlling Alerts
Day 03
Query Triggers
• SELECT Statements Issued During Query Processing
• WHERE and ORDER BY Clauses and the RUNTIME Properties
• Writing Query Triggers
• Query Array Processing
• Coding Triggers for Enter-Query Mode
• Overriding Default Query Processing
• Obtaining Query Information at Run Time
Validation
• Validation Process
• Controlling Validation Using Properties
• Controlling Validation Using Triggers
• Tracking Validation Status
• Using Built-ins to Control When Validation Occurs
Navigation
• Navigation Overview
• Understanding Internal Navigation
• Using Object Properties to Control Navigation
• Writing Navigation Triggers: When-New--Instance, Pre- and Post- Triggers
• The Navigation Trap
• Using Navigation Built-ins in Triggers
Transaction Processing
• The Commit Sequence of Events
• Characteristics and Common Uses of Commit Triggers
• Testing the Results of Trigger DML
• DML Statements Issued During Commit Processing
• Overriding Default Transaction Processing
• Running Against Data Sources Other Than Oracle
• Getting and Setting the Commit Status
• Implementing Array DML
Writing Flexible Code
• What Is Flexible Code?
• Using System Variables for Flexible Coding
• Using Built-in Subprograms for Flexible Coding
• Referencing Objects by Internal ID
• Referencing Items Indirectly
Sharing Objects and Code
• Working with Object Libraries
• Working with SmartClasses
• Reusing PL/SQL
• Working with PL/SQL Libraries
Using WebUtil to Interact with the Client
• Benefits of WebUtil
• Integrating WebUtil into a Form
• Interacting with the Client
Introducing Multiple Form Applications
• Multiple Form Applications Overview
• Starting Another Forms Module
• Defining Multiple Form Functionality
• Sharing Data Among Modules
Back to Oracle Courses...