ORA10g402 - Oracle 10g Forms II: Customize Internet Applications

Course ORA10g402

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

The objective of this 5-day course is to provide application software developers with the skills to build and customize advanced enterprise-scale Web applications using the Oracle10g ODS Forms product.

Return to Top

Audience

The target audience for this course is Web application developers and designers, as well as their management, who will be developing and customizing complex Internet applications using the Oracle10g ODS Forms product.

Return to Top

At Course Completion

At the end of this course, the student will be able to:

• Build client-side triggers and program units to customize forms applications.
• Dynamically control form objects and behavior during runtime.
• Take advantage of built-in functions and procedures.
• Write efficient and well-tuned client-side logic.
• Integrate multiple Oracle10g modules into enterprise applications.
• Exploit object-oriented features to maximize reuse of components.
• Use specialized techniques such as hierarchical trees, procedure data blocks, and timers.
• Integrate forms logic with database server objects into a cohesive solution.

Return to Top

Prerequisites

Before attending this course, students must have:

• Completed ora10g008, Oracle Database 10g: Introduction to SQL I, or equivalent.
• Completed ora10g009, Oracle Database 10g: Introduction to SQL II, or equivalent.
• Completed ora10g101, Oracle Database 10g: Program with PL/SQL, or equivalent.
• Completed ora10g401, Oracle10g Forms I: Build Internet Applications, or equivalent.

Suggested Next Course

• ora10g501, Oracle Reports 10g: Build Reports
• ora10g403, Oracle 10g Forms III: New Features & Web Deployment

Return to Top

Certified Professional Exams

This course, along with ora10g401, Oracle 10g Forms I: Customize Internet Applications, will help the student prepare for the following Certified Professional exam:

• Exam 1Z0-141, Oracle9i Forms Developer: Build Internet Applications

Following the training sessions, Oracle Corporation recommends six-months production experience with the technology prior to taking the certification examinations. While this is good practice, it may not be necessary for all individuals.

Return to Top

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top

Course Outline

DEVELOPING PROGRAMS WITHIN FORMS

• ABOUT ORACLE10g PROGRAM DEVELOPMENT
• UNDERSTANDING CLIENT-SIDE TRIGGERS
• UNDERSTANDING CLIENT-SIDE PROGRAM UNITS
• UNDERSTANDING BUILT-IN SUBPROGRAMS
• UNDERSTANDING PL/SQL LIBRARIES

THE PL/SQL EDITOR

• UNDERSTANDING PL/SQL EDITOR CONCEPTS
• USING THE PL/SQL EDITOR
• USING THE PL/SQL EDITOR PRODUCTIVITY FEATURES

THE VALIDATION TRIGGERS

• USING THE VALIDATION TRIGGERS
• USING WHEN-VALIDATE-ITEM

UNDERSTANDING BUILT-INS USING ALERTS

• UNDERSTANDING BUILT-IN CONCEPTS
• CATEGORIES OF BUILT-INS
• CALLING BUILT-IN PROCEDURES VS. FUNCTIONS
• USING OBJECT ID REFERENCES
• REFERENCING OBJECT PROPERTIES
• USING THE ALERT BUILT-INS

USING THE ITEM BUILT-INS

• UNDERSTANDING ITEM BUILT-INS
• USING GENERAL ITEM BUILT-INS
• USING NAVIGATION ITEM BUILT-INS
• USING ITEM BUILT-INS TO GET & SET PROPERTIES

SPECIALTY ITEM BUILT-INS

• ABOUT SPECIALTY ITEM BUILT-INS
• USING GUI CONTROL ITEMS BUILT-INS
• USING MENU ITEM BUILT-INS
• USING IMAGE ITEM BUILT-INS

USING BUILT-INS FOR OTHER FUNCTIONAL OBJECTS

• ABOUT THE FUNCTIONAL OBJECT BUILT-INS
• USING THE BLOCK BUILT-INS
• GET_BLOCK_PROPERTY() & SET_BLOCK_PROPERTY()
• TRUE / FALSE Properties List
• USING THE RECORD BUILT-INS
• USING THE LOV BUILT-INS
• USING THE EDITOR BUILT-INS
• USING THE RELATION BUILT-INS
• ABOUT RESTRICTED BUILT-INS

USING APPLICATION & MODULE BUILT-INS

• ABOUT THE APPLICATION & FORM BUILT-INS
• USING THE APPLICATION BUILT-INS
• USING THE FORM BUILT-INS

SPECIALIZED PROGRAMMING TECHNIQUES

• ABOUT THE TECHNIQUES
• USING SYSTEM VARIABLES
• USING GLOBAL VARIABLES
• USING INDIRECT REFERENCES

INTERMEDIATE-LEVEL TRIGGERS AND BUILT-INS

• ABOUT INTERMEDIATE-LEVEL TRIGGER CATEGORIES
• USING END USER ACTION TRIGGERS
• USING NAVIGATIONAL TRIGGERS
• USING QUERY TRIGGERS & BUILT-INS
• USING BLOCK PROCESSING TRIGGERS
• USING KEY TRIGGERS & BUILT-INS

DYNAMIC CONTROL OVER VISUAL OBJECTS

• WORKING WITH VISUAL OBJECTS
• USING THE WINDOW BUILT-INS & TRIGGERS
• USING THE CANVAS BUILT-INS

ERROR CUSTOMIZATION

ADVANCED FORMS CUSTOMIZATION

• ABOUT RECORD GROUPS & DYNAMIC LISTS
• USING RECORD GROUPS
• USING DYNAMIC LISTS

APPLICATIONS WITH MULTIPLE MODULES

• ABOUT MULTIPLE MODULES & PARAMETER LISTS
• CALLING FORM MODULE BUILT-INS

OBJECT ORIENTATION, PROPERTY CLASSES

• UNDERSTANDING OBJECT ORIENTATION CONCEPTS
• OBTAINING INHERITANCE WITH PROPERTY CLASSES

OBJECT ORIENTATION, BUILDING REUSABLE COMPONENTS

• ABOUT REUSABLE COMPONENTS
• OBTAINING INHERITANCE WITH OBJECTS
• USING OBJECT GROUPS
• USING OBJECT LIBRARIES

OBJECT ORIENTATION, WRITING REUSABLE LOGIC

• UNDERSTANDING ADVANCED OBJECT PRINCIPLES
• OBJECT ORIENTATION WITH PACKAGES
• OBJECT ORIENTATION WITH PL/SQL LIBRARIES

INTEGRATING SERVER-SIDE LOGIC

• ACCESSING DATABASE SERVER-SIDE LOGIC
• INTEGRATING DATABASE CONSTRAINTS
• INTEGRATING DATABASE PROCEDURES
• INTEGRATING DATABASE TRIGGERS

BUILDING STORED PROCEDURE DATA BLOCKS

• CHOOSING THE DATA BLOCK SOURCE
• IMPLEMENTING STORED PROCEDURE DATA BLOCKS

HIERARCHICAL TREES

• WHAT ARE HIERARCHICAL TREES?
• CREATING THE HIERARCHICAL TREE
• POPULATING THE TREE WITH DATA
• HIERARCHICAL TREE TRIGGERS & SYSTEM VARIABLES
• USING FTREE() & HIERARCHICAL TREE BUILT-INS
• ADD_TREE_DATA()
• ADD_TREE_NODE()
• DELETE_TREE_NODE()
• GET_TREE_NODE_PARENT()
• GET_TREE_NODE_PROPERTY()
• GET_TREE_PROPERTY()
• GET_TREE_SELECTION()
• POPULATE_GROUP_FROM_TREE()
• POPULATE_TREE()
• SET_TREE_NODE_PROPERTY()
• SET_TREE_PROPERTY()
• SET_TREE_SELECTION()
• FIND_TREE_NODE()

Return to Top