Oracle Forms and Reports
Module 1 : Introducing Oracle Forms Developer and Forms Services
- Grid Computing
- Oracle 10g Products
- Oracle Application Server 10g Architecture
- Benefits and Components of Oracle Developer Suite 10g
- Running a Forms Developer Application
- Working in the Forms Developer Environment
Module 2 : Creating Forms Modules
- Creating a Basic Forms Module
- Creating a Master-Detail Forms Module
- Modifying the Data Block
- Modifying the Layout
Module 3 : 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
Module 4 : 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
Module 5 : 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
Module 6 : 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
Module 7 : 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
Module 8 : Debugging Triggers
- The Debugging Process
- The Debug Console
- Setting Breakpoints
- Debugging Tips
- Running a Form in Debug Mode
- Stepping through Code
Module 9 : 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
- Interacting with JavaBeans
Module 10 : 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
- Handling Server Errors
Module 11 : Query Triggers
- SELECT Statements Issued During Query Processing
- WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
- Writing Query Triggers
- Query Array Processing
- Coding Triggers for Enter-Query Mode
- Overriding Default Query Processing
- Obtaining Query Information at Run Time
Module 12 : Validation
- Validation Process
- Controlling Validation Using Properties
- Controlling Validation Using Triggers
- Performing Client-Side Validation with PJCs
- Tracking Validation Status
- Using Built-ins to Control When Validation Occurs
Module 13 : 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
Module 14 : 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
Module 15 : 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
Module 16 : Sharing Objects and Code
- Working with Object Libraries
- Working with Smart Classes
- Reusing PL/SQL
- Working with PL/SQL Libraries
Module 17 : Introducing Multiple Form Applications
- Multiple Form Applications Overview
- Starting Another Forms Module
- Defining Multiple Form Functionality
- Sharing Data Among Modules
Module 18 : Basic Concepts
- Oracle Reports Builder
- Reports
- Report Styles
- Wizards
- The Object Navigator
- The Report Editor
- Data Model Objects
- Layout Objects
- Parameter Form Objects
- The Property Instructor
- Runtime Views
- Oracle Reports Components
Module 19 : Advanced Concepts
- Reports
- Web Reports
- Data Model Objects
- Layout Objects
- Parameter Form Objects
- PL/SQL
- Templates
- Output Formats and Capabilities
- Data Sources
- Debugging Tools
Module 20 : Visual Index
- Building Basic Reports
- Building Group Reports
- Building Reports w/ Special Formatting
- Building Matrix Reports
- Building Reports for Business Cases
- Building Reports w/ PL/SQL and Java
- Building Reports w/ Pluggable Data Sources