| |
| |
 |
| |
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 |
| |
| Introduction to Oracle Forms
Developer and Oracle Forms Services |
- Features and Benefits of Oracle Forms Developer and Oracle
Forms Services
- Navigating Around the Form Builder Interface
- Form Builder Components: Object Navigator
- Form Builder Components: Property Palette
- Form Builder Components: Layout Editor
- Form Builder Components: PL/SQL Editor
|
|
| Running
a Form Developer Application |
- The Runtime Environment
- Navigating a Forms Application
- Environment variables and Y2K compliance
- Retrieving Both Restricted and Unrestricted Data from
the Database into a Forms Application
- Identifying the Two Modes of Operation :Enter Query &
Normal mode
- Inserting, Updating, and Deleting Records
- Displaying Database Errors
|
|
| Working
in the Form Builder Environment |
- Identifying the Main Forms Executables
- Identifying the Main Components of Form Builder
- Identifying the Main Objects in a Form
- Testing a Form : Starting Oracle Containers for J2EE(OC4J)
- Testing a Form : Runform Button
|
|
| Creating
a Basic Form Module |
- Creating a Form Module
- Creating a Data Block
- Modifying the Layout
- Saving and Running a Form Module
- Identifying Form File Formats and Their Characteristics
- Creating Data Blocks with Relationships
- Running a Master-Detail Form Module
|
|
| Working
with Data Blocks and Frames |
- Managing Object Properties
- Visual Attributes, Font, Pattern & Color Pickers
- Controlling the Behavior and Appearance of Data Blocks
- Creating Data Blocks that Do Not Directly Correspond to
Database Tables
- Navigation Properties, Records Properties & Database
Properties
- Deleting Redundant Data Blocks and Their Components
|
|
| Working
with Text Items |
- Describing Text Items
- Creating a Text Item
- Modifying the Appearance of a Text Item
- Controlling the Data in a Text Item
- Altering the Navigational Behavior of a Text Item
- Enhancing the Relationship Between the Text Item and the
Database
- Adding Functionality to a Text Item
- Including Helpful Messages
|
|
| Creating
Lists of Values (LOVs) and Editors |
- Describing LOVs and Editors
- Designing, Creating, and Associating LOVs with Text Items
- Creating an LOV Using the LOV Wizard
- Creating Editors and Associating Them with Text Items
|
|
| Creating
Additional Input Items |
- Identifying the Item Types that Allow Input
- Creating a Check Box
- Creating a List Item
- Creating a Radio Group
|
| |
|
|
|
| |
