Oracle Forms & Reports

INTRODUCTION

Course Contents:

• Prerequisites
• Developer Tools
• Starting Developer tools under Windows
• The Oracle Forms Builder Main Screen
• Oracle Forms Object Navigator
• Connecting to the Database
• Oracle Forms Design
• Creating and Running an Oracle Form with

SINGLE BLOCK

• Creating a New Block
• The Layout Editor
• Displaying Properties
• Saving, Generating and Running Forms
• Saving a Form
• Compiling/Building a Form
• Running a Form
• Running an Oracle Form under 9iDS
• Running an Oracle Form under 11g
• Query By Example
• Exercise: Creating a Single Block Form

CREATING A MASTER/DETAIL FORM

• The Master/Detail Relationship
• Steps to Create a Master/Detail Form
• Create the Master Block
• Create the Detail Block
• Relation Properties of a Master/Detail Form
• Program Units in a Master/Detail Form
• Extending Master/Detail Forms
• Exercise: Creating a Master/Detail Form

ORACLE FORMS PROGRAM UNITS AND STORED PROGRAM UNITS

• Creating Procedures in Oracle Forms
• Add a new item to the EMPLOYEE Block
• Create a Procedure to Count Other

DEPARTMENT MEMBERS

• Create a Trigger to Call the Procedure
• Save, Compile and Run the Form
• Creating Stored Program Units (Procedures) in

LIST OF VALUES (LOVS) AND NON-BASE TABLE FIELDS

• Creating a List of Values
• Non-Base Table fields
• Adding a New Item to an Existing Data Block
• Creating a Trigger
• Create a new List of Values
• Exercise: Creating an LOV and Non-Base Table field

SQL*PLUS

• Additional Stored Procedures and Triggers
• Generating unique or consecutive

IDENTIFIERS USING THE TABLE

• Generating unique or consecutive

IDENTIFIERS USING AN ORACLE SEQUENCE

• Checking constraints at the client
• Adding Alerts (Pop-up Messages)
• Automatic Forms Query
• Populate items with default values
• Attaching functionality to command buttons
• Passing parameters between forms
• Exercise: Procedures and Triggers

ORACLE REPORTS BASICS

• Starting Developer tools under Windows
• The Oracle Reports Object Navigator
• Creating Reports in Oracle Reports
• Creating a Single-Table Report
• Specify the Data Model and Layout
• Saving, Generating and Running the Report
• Exercise: Creating a Report
• Creating a Master/Detail Report
• Specify the Master/Detail Data Model and

LAYOUT

• Saving and Running the Master/Detail

REPORT

• Exercise: Creating a Master/Detail Report
• Parameter forms in Oracle Reports
• Building a Custom Parameter Form
• Creating Menus in Oracle Forms
• The Oracle Forms Menu Hierarchy