Oracle Forms - Part II
 
 

Oracle Forms - Part II

Course Code: OF2

Duration: 3 days

S6

Oracle Forms - Part II Course Overview

Designed for programmers and software developers who are already familiar with the basic features of Oracle Forms. This Oracle Forms - Part II course is designed to introduce delegates to the more advanced features of Oracle Forms.

The delegate will learn and acquire skills as follows:

  • Implementing mouse and key triggers
  • Creating and using timers
  • Generating and manipulating runtime record groups
  • Controlling Data Block relationships explicitly
  • Building multiple-form applications
  • Generating custom menus
  • Defining Data Blocks based on objects, queries and procedures
  • Using Database Server features within a form
  • Reusing standard components and Java Beans

Who will the Course Benefit?

Programmers and other software development personnel who need to write write Oracle Forms applications which interface with an Oracle database. Practical experience of the Oracle PL/SQL programming language and some experience of designing basic Oracle Forms applications are pre-requirements for this Oracle Forms - Part II course.

Course Objectives

To provide the skills needed to design, develop and enhance end-user write Oracle Forms applications which interact with an Oracle Relational Database.

Requirements

Attendance on the pre-requisite courses or practical experience in developing basic Oracle Forms applications.

Pre-Requisite Courses

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.


 

Course Contents

Oracle Forms - Part II Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: AN INTRODUCTION

  • Notes on Course Content
  • Preparation
  • Exercise: Creating Basic Oracle Forms Applications

Session 2: MOUSE AND KEY TRIGGERS

  • Mouse Triggers
  • Cursor Styles
  • Key Triggers
  • Exercise: Implementing Mouse and Key Triggers

Session 3: TIMERS

  • Use of Timers
  • Creating and Handling Timers
  • Timer Triggers and Built-ins
  • Exercise: Creating a Clock Timer

Session 4: RECORD GROUPS

  • LOVs and Record Groups
  • Record Group Types
  • Creating Run-time Record Groups
  • Built-in Procedures and Functions
  • Record Groups and Lists
  • Exercise: Using Run-time Record Groups

Oracle Forms - Part II Training Course

Session 5: DATA BLOCK RELATIONSHIPS

  • Relation Object Properties
  • Creating Relationships Manually
  • Procedures and Triggers for Coordination
  • Modifying Default Functionality
  • Exercise: Creating and Modifying a Relation Object

Session 6: MULTI-FORM APPLICATIONS

  • Calling Other Forms
  • The OPEN_FORM Procedure
  • The CALL_FORM Procedure
  • The NEW_FORM Procedure
  • Related Built-ins
  • Passing Data between Forms
  • Creating Parameters and Parameter Lists
  • Exercise: Calling Oracle Forms and Passing Parameters

Session 7: CREATING CUSTOM MENUS

  • Menu Modules, SubMenus and Menu Items
  • The Menu Editor
  • Menu and Menu Item Properties
  • PL/SQL in Menu Modules
  • Menu Item Built-ins
  • Menu Security
  • Menu Parameters
  • Popup Menus
  • Exercise: Generating a Custom Menu

Session 8: HANDLING DATABASE OBJECTS

  • Object Support and Object Types
  • Object Tables
  • Column Objects
  • Handling REF Columns
  • Exercise: Handling Objects with an Oracle Form

Oracle Forms - Part II Training Course

Session 9: USING OTHER DATA SOURCES

  • Data Source Types
  • Using a FROM Clause Query
  • Using Procedures which return REF Cursors
  • Using Procedures which return PL/SQL Index-By Tables
  • Implementing DML using Packaged Procedures
  • Exercise: Defining and using FROM Clause Query
  • Exercise: Defining and using a Packaged Procedure

Session 10: USING ORACLE DATABASE FEATURES

  • Database Functionality
  • Handling PL/SQL Code
  • Handling Database Server Errors
  • Using the FORMS_DDL Package
  • DDL Functionality
  • Exercise: Using the FORMS_DDL Package

Session 11: REUSABLE COMPONENTS

  • Reusable Component Definition
  • Oracle-Supplied Components
  • Using Oracle's Calendar Class Component
  • Notes on Active X Controls
  • JavaBeans and PJCs
  • Exercise: Implementing the Calendar Component
  • Exercise: Implementing Pluggable Java Components

Session 12: INCLUDING CHARTS AND REPORTS

  • Including Charts
  • Oracle Reports Overview
  • Running an Oracle Report
  • Integrating Oracle Reports with Oracle Forms
  • Viewing an Oracle Report
  • Exercise: Interfacing with an Oracle Report
 

Oracle Forms - Part II

Duration: 3 days

RRP: £1,635.00 exc. VAT 


Upcoming Scheduled Events
Next 6 months

London
Start Date   Spaces Book
13 Mar 2019   Spaces StayAhead - Course Running Book
 
05 Jun 2019   Spaces StayAhead - Course Running Book
 
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
 

Course Reviews

Excellent course. The trainer was very helpful. Thanks

Mike - Analyst/Programmer - Utilities


Great thorough teaching,well supported by worked exercises and examples.

Kirsten - Associate Consultant - Outsourcing


Excellent follow up course. Reinforcing the first course and adding some more complex solutions. Well delivered by the lecturer in a friendly and engaging manner.

James - Analyst Programmer - Utilities


 
 
 
        Home             Let Us Call You
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!




Our Course Curriculum

 
 
 
 
 



Our Ratings

Instructor
Quality
 

97.48%

Course
Practical
 

92.63%

Overall
Courseware
 

94.44%

Overall
Course
 

96.46%

+44 (0)20 7600 6116
sales@stayahead.com
Copyright © 2019 StayAhead Training Ltd
Cookies   /   Privacy Policy