Loading...

Oracle 9i Forms Part 1

Course code: O210

5 days

This practical course covers the fully featured functionality found within Oracle's enterprise graphical development tool, Oracle 9i 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 9i Forms.

Training Course Contents

Introduction

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

Getting Started

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

Formatting a Form

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

Multiple 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

Reports

  • Creating Report Objects based on a block
  • Report Object Properties
  • Running 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

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

Menus

  • Basic Menu Modules
  • Popup Menus

Objects & Interface Items

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

Forms Events & PL/SQL

  • 9i Triggers
  • 9i System Variables
  • 9i 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
  • Controlling Oracle 8 Objects
  • Building Hierarchy Trees
  • Using Hierarchy Trees
  • PL/SQL Editor Enhancements
  • Using Dynamic PL/SQL
Contact us for more information