ORACLE FORMS REPORTS ONLINE TRAINING
ENROLL NOW

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

 

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

 

If you want to know more about ORACLE FORMS REPORTS ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com

ENROLL NOW