| |
| |
 |
| |
ORACLE 9i DEVELOPER SUITE FORMS & REPORTS
|
|
|
| |
|
Oracle9i Developer Suite Forms: Build Internet Applications |
| |
Course duration(in
hrs): 28
Course Objectives:
- Use iSQL*Plus to format reports
- Use basic iSQL*Plus commands
- Retrieve, insert, update, and delete data
- Describe relational and object relational database concepts
- Create and maintain database objects
- Control transactions
- Control data and user access
|
| |
| Course Topics |
| |
| Creating
Noninput Items |
- Identifying Item Types that Do Not Allow Input
- Creating a Display Item
- Creating an Image Item
- Creating a Sound Item
- Creating a Button
- Including Tooltips
- Creating a Calculated Field
- Including a Hierarchical Tree Control
|
|
| Creating
Windows and Content Canvases |
- Describing the Relationship Between Windows and Content
Canvas-Views
- Displaying a Form Module in Multiple Windows
- Displaying a Form Module on Multiple Layouts
|
|
| Working
with Other Canvas-Views |
- Describing the Different Types of Canvas-View
- Identifying the Appropriate Canvas-View Type for Different
Scenarios
- Creating an Overlay Effect on the Interface
- Creating a Toolbar
- Creating a Tabbed Interface
|
|
| Introduction
to Triggers |
- Identifying the Different Trigger Categories
- Planning the Type and Scope of Triggers in a Form
- Describing the Properties that Affect Trigger Behavior
|
|
| Producing
Triggers |
- Writing Trigger Code
- Explaining the Use of Built-In Subprograms in Oracle Developer
Applications
- Identifying the When-Button-Pressed Trigger and Knowing
When to Use It
- Identifying the When-Window-Closed Trigger and Knowing
When to Use It Debugging Triggers and Program Units
|
|
| Adding
Functionality to Items |
- Adding Functionality to GUI Items
- Supplementing the Functionality of Input Items Using
Triggers
- Supplementing the Functionality of Noninput Items Using
Triggers
- Handling Errors Using Built-In Subprograms
|
|
| Runform
Messages and Alerts |
- Describing the Default Messaging Behavior of a Form
- Identifying the Different Types of Forms Messages
- Controlling System Messages
- Creating and Controlling Alerts
|
|
| Query
Triggers |
- Explaining the Processes Involved in Querying a Data Block
- Identifying Where Triggers Can Be Coded to Control the
Query Process
- Writing Triggers that Screen Query Conditions
- Writing Triggers to Supplement Query Results
- Controlling Trigger Action Based Upon the Query Status
of the Form
|
|
| Validation
|
- The Effects of the Validation Unit upon a Form
- Employing Additional Forms Features for Validation
- Controlling Validation Using Triggers
- Supplementing Default Validation
- Navigation
- Distinguishing Between Internal and External Navigation
- Describing and Using the Navigation Triggers
- Writing Navigation in Triggers
|
|
| Transaction
Processing |
- Explaining the Process Used by Oracle Forms Developer
to Apply Users Changes to the Database
- Describing the Commit Sequence of Events
- Supplementing Transaction Processing
- Allocating Sequence Numbers to Records as They Are Applied
to Tables
|
|
| Writing
Flexible Code |
- Defining Flexible Code
- The Advantages of Using System Variables
- Identifying Built-In Subprograms that Assist Flexible
Coding
- Referencing Objects by Internal ID
- Referencing Items Indirectly
|
|
| Building
Multiple-Form Applications |
- Defining Methods of Invoking Addition Form Modules
- Opening, Calling, and Closing Form Modules
- Controlling Open Forms Modules and Called Form Modules
- Managing Transaction Processing for Open and Called Forms
- Using Form Parameters
- Creating and Manipulating Parameter Lists
- Passing Data Between Form Modules
|
| |
|
|
|
| |
