Loading...

Oracle 10g Forms Part 1

Course code: O110

5 days

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

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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

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
Contact us for more information