COURSE DESCRIPTION
This lab-intensive course is designed to lead application software developers through the steps involved in building enterprise-scale Internet applications using the Oracle9iDS Forms product.
DURATION: 5 Days
OBJECTIVES
- Rapidly build form applications using the wizards and other productivity features.
- Building complex form modules using the Forms Builder.
- Building menu bar modules using Forms Builder.
- Customizing the precise appearance of modules using the Layout Editor.
- Linking individual modules within an application.
- Including simple PL/SQL programs to customize module behavior.
- Understanding the Oracle Forms runtime environment
INTENDED AUDIENCE
Application developers and designers, as well as their management, who will be developing Internet applications using the Oracle10g ODS Forms product.
PREQUISITES
Oracle Foundation Classes (SQL Basics & SQL Plus and PL/SQL Workshop) or familiarity with SQL and PL/SQL or equivalent work experience.
FORMAT/MATERIALS
This course includes a combination of lecture, discussion and numerous computer workshops. Students will receive an extensive course manual covering Oracle Forms, which will be a valuable reference after class.
COURSE OUTLINE
AN INTRODUCTION TO ORACLE10g ODS & FORMS
• About Oracle10g ODS
• About Oracle10g Enterprise Architecture
• More About Oracle Forms
ABOUT THE WIZARDS
• An Introduction to the Wizards
• Forms Builder Welcome Wizard
• Using Data Block Wizard
• Using Layout Wizard
MODIFYING FORMS WITH WIZARDS
• Building Master-Detail Block Relationships
• Using Re-Entrant Wizards
• Modifying Forms with Wizards
FORMS RUNTIME
• Understanding Forms Runtime
• Default Run Time Menu
• Understanding Query Mode
• Understanding Row Locking
• Understanding Commit Processing
BEGINNING APPLICATION DEVELOPMENT
• Organizing Developer's Desktop
• How You Might Approach Development
• Workshop Section
• Beginning Application Development
FORMS BUILDER INTERFACE - THE OBJECT NAVIGATOR
• Using Object Navigator
• Object Navigator Edit Menu
• Object Navigator View Menu
• Object Navigator Program Menu
• Object Navigator Tools Menu
FORMS BUILDER INTERFACE
• The Property Pallet
• Status Line
• Using LOV (List of Values) Wizard
• Involking LOV at Runtime
LAYOUT EDITOR
• What Is Layout Editor?
• Concepts within Layout Editor
• Using Tool Palette
• The Layout Editor Edit Menu
• The Layout Editor View Menu
• The Layout Editor Layout Menu
THE FILE AND HELP MENUS
BUILDING TEXT AND DISPLAY ITEMS
• Using Text Items
• Using Calculation Text Items
• Using Display Items
BUILDING FORMS GUI ITEMS
• Using Check Boxes
• Using Radio Groups & Radio Buttons
• Using List Items
• Using Buttons
• Using Image Items
INTRODUCTION TO CLIENT-SIDE TRIGGERS
• Understanding Client-Side Triggers
• Using PL/SQL Editor
BUILDING MODULES AND DATA BLOCKS
BUILDING RELATIONS AND VISUAL ATTRIBUTES
BUILDING OTHER FORM OBJECTS
• Building Alerts
• Building LOVs and Record Groups
• Building Editors
• Building Parameters
BUILDING CANVASES, FRAMES AND WINDOWS
BUILDING CUSTOM MENUS
• Understanding the Menu Bar
• Menu Module Objects
• Menu Item Types
• The Menu Editor
• Creating A Menu Bar The Easy Way
• Menu Item Properties
• Menu Module Properties
• Menu Submenu Properties
• Attaching A Menu To Form
ADVANCED MENU CONCEPTS
THE REPORT WIZARD
THE FORM COMPILER
THE MAIN APPLICATION FORM