Oracle Forms Reports

Oracle

Oracle Forms Reports

INTRODUCTION

  • 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 a

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

For More information on this course,

Contact : +91 8790035426 , +91 8790035436
EMail ID : enquiry@virtuoustrainers.com
Skype ID : virtuoustrainers