TRAINING

Enroll Now

Oracle Forms and Reports Training (D2K Training)

Learn to build complex and sophisticated reports from any data source format using Oracle Reports Developer. Understand how to configure, administer and use Oracle Forms Builder to rapidly build scalable, high-performance applications for the Web.

Learn Forms and Reports from United Global Soft

Oracle Forms and Reports designs and builds applications for enterprises. With Oracle Forms and Reports Training, learn to build complex and sophisticated reports from any data source format using Oracle Reports Developer. Gain the skills to configure, administer and use Oracle Forms Builder to rapidly build scalable, high-performance applications for the Web.

What Will I Learn?

• Learn Developing Forms and Reports with the help of Data base Tables
• Developing the Data Blocks, Canvases and Windows
• Creating of Alerts and Lov's in Forms
• Developing Master Detail Forms
• Passing the Parameters from One form to another Form
• Creating the New Menu's and attaching the form
• Develop the New Report with the help of Base table
• Developing Different Report Styles
• Creating of Parameters in Report
• Adding Extra Column to the Report (Formula, Summary and Placeholder)
• Using Data Links (Master Detail Reports)
• Developing the Reports Manually
• Report Triggers

Prerequisites:

Basic Knowledge of SQL and PLSQL

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

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

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

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