Oracle Forms - Part II

Focus on Training

Course

In London-City

£ 1,395 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London-city

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. 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. Learning Objectives o provide the skills needed to design, develop and enhance end-user write Oracle Forms applications which interact with an Oracle Relational Database. The delegates will practise: Implementing mouse and key triggersCreating and using timersGenerating and manipulating runtime record groupsControlling Data Block relationships explicitlyBuilding multiple-form applicationsGenerating custom menusDefining Data Blocks based on objects, queries and proceduresUsing Database Server features within a formReusing standard components and Java Beans

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • PL/SQL
  • SQL
  • Database
  • Server
  • Java

Course programme

Course Contents - DAY 1Course 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
Course Contents - DAY 2Session 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
Course Contents - DAY 3Session 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

See related categories

Oracle Forms - Part II

£ 1,395 + VAT

The best Oracle courses

See all

See all