Session 1: AN INTRODUCTION
- Notes on Course Content
- Preparation
Session 2: MOUSE AND KEY TRIGGERS
- Mouse Triggers
- Cursor Styles
- Key Triggers
Session 3: TIMERS
- Use of Timers
- Creating and Handling Timers
- Timer Triggers and Built-ins
Session 4: RECORD GROUPS
- LOVs and Record Groups
- Record Group Types
- Creating Run-time Record Groups
- Built-in Procedures and Functions
- Record Groups and Lists
Session 5: DATA BLOCK RELATIONSHIPS
- Relation Object Properties
- Creating Relationships Manually
- Procedures and Triggers for Coordination
- Modifying Default Functionality
Session 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
Session 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
Session 8: HANDLING DATABASE OBJECTS
- Object Support and Object Types
- Object Tables
- Column Objects
- Handling REF Columns
Session 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
Session 10: USING ORACLE DATABASE FEATURES
- Database Functionality
- Handling PL/SQL Code
- Handling Database Server Errors
- Using the FORMS_DDL Package
- DDL Functionality
Session 11: REUSABLE COMPONENTS
- Reusable Component Definition
- Oracle-Supplied Components
- Using Oracle's Calendar Class Component
- Notes on Active X Controls
- JavaBeans and PJCs
Session 12: INCLUDING CHARTS AND REPORTS
- Including Charts
- Oracle Reports Overview
- Running an Oracle Report
- Integrating Oracle Reports with Oracle Forms
- Viewing an Oracle Report