Oracle 10g Forms Part 1 (O110) Training Course

Training Course Objectives

This practical course covers the fully featured functionality found within Oracle's enterprise graphical development tool, Oracle 10g Forms.

Who Should Attend

• Oracle Analyst/Programmers
• Oracle Technicians
• Oracle DBA's
• Oracle Developers

Training Course Prerequisites

• PC Fundamentals
• Oracle 10g SQL (O011)
• Oracle 10g PL/SQL (O021)
• View Learning Path

Training Course Duration

5 Days

Training Course Contents

Introduction

• Invoking Forms Builder
• Forms Development Tools Overview
• Property Palettes

Getting Started

• Building a basic Form
• Forms Runtime Overview
• Forms object structure and Object Navigator
• Block concepts
• Block data sources
• Data Block Wizard using a stored procedure
• Layout/Chart/LOV wizard

Formatting a Form

• Layout Editor
• Formatting Tools
• Visual Attributes
• Working with Frames
• Working with Canvases
• Property Classes

Mulitple Block Forms

• Creating forms based on multiple blocks
• Building Block Relationships
• Relationship properties

Windows and Canvases

• Stacked Canvases
• Toolbar Canvases
• Tab Canvases
• Window Properties
• Items
• Check Boxes
• Radio Groups
• Primary Key Display Items
• Foreign Key Display Items
• Synchronized Display Items
• Calculated Items
• Summary Items
• Retrieving Image Items
• Storing Images in the database
• Buttons
• JavaBean area

Reports

• Create Report Objects based on a block
• Report Object Properties
• Run Existing Reports using Run Product
• Building Parameter Lists to Run Reports

Data Lists

• List Items
• Simple LOV
• Multiple column LOV
• LOV Properties
• Populating list items with Record Groups
• Creating record groups programmatically

PL/SQL in Forms

• Program Units
• PL/SQL Libraries
• Forms Triggers
• Forms Built Ins
• The Navigation Unit
• Basing a Form on a stored procedure
• Using Debug
• Alerts

Navigating Form Applications

• Applications
• Forms Parameters
• Global Variables
• Call/Open/New/Go Form

Menus

• Basic Menu Modules
• Popup Menus

Control Objects & Interface

• Items
• Property Palette
• Renamed Properties
• New Properties
• Prompt Orientation
• Query All Records Block Property
• ToolTips Property
• Calculated Fields
• Formula/Summary Calculations
• Tab Canvasses
• Stacked canvas enhancements
• Frames
• Visual Attribute Enhancements
• Graphic Object Functionality
• Sound items
• Images

Forms Events & PL/SQL

• Triggers
• System Variables
• Built-in Subprograms
• Dynamic SQL
• Default Keyword
• Composite Datatypes
• PL/SQL Records
• PL/SQL Tables
• Combining PL/SQL Records and Tables

Development Techniques

• Smart Triggers
• Array DML Processing
• Object Sub-classing
• Object Libraries
• Smart Classes
• Template Forms
• Building Hierarchy Trees
• PL/SQL Editor Enhancements
• Using Dynamic PL/SQL
• Using Pluggable Java
• Components (PJC's).
• Client interaction with WebUtil

Next Available Dates

• 20th Sep 2010  Leeds
• 18th Oct 2010  Manchester
• 25th Oct 2010  Leeds
• 8th Nov 2010  Edinburgh