Oracle Forms Release 6i Course UK
Oracle Forms Release 6i Training Course Summary
Objectives
To enable the creation, manipulation, extraction of data from an Oracle database using the Oracle Forms Interface. It is essential to have a good understanding of the SQL Language. The course takes you through creating a basic form and enhancing it to create the basis of a complex application incorporating formatting techniques and images, logos and objects. The course is organised into chapters covering the course objectives in a lecture format interspersed by sets exercises designed to illustrate the points covered and are completed by the delegate. A text book which includes advanced techniques not covered in this course is provided with this course.
Course Content
Course content has been developed for real-world, commercial
scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
4 Days
Who Should Attend
The course is suitable for any personnel involved in the maintenance and development of Oracle applications.
Pre-Requisite Skills
Some degree of computer literacy is required and a basic knowledge
of SQL and PL/SQL.
What You Will Learn
1.Create and maintain Oracle Forms.
2.Use and enhance the Default Forms.
3.Produce complex Forms as Part of an Application.
Associated Course(s)
Oracle Intro to
SQL
Oracle
Intro to PL/SQL
Oracle
6i Forms
Oracle
6i Reports
Oracle Forms
& Reports Hybrid
Oracle
DBA
Oracle
9i New Features
Oracle
Performance Tuning
Introduction to Forms
· What is Reports and what is it used for?
Invoking the Forms Designer.
Overview of the Designer interface.
Creating a basic form.
- The Object Navigator
Creating a Base Table Block.
Adding a Detail Block.
Saving and Generating the Form
The Runtime Interface
Querying the Database
Unrestricted Queries
Queries using Wild Cards
Normal & Enter Query Mode
Manipulating the Database
Inserting, Updating, Deleting.
Transaction Control
Enhancing the Form
Formatting the Form Layout
Modifying Object Properties
Enhancing Functionality with PL/SQL
Deploying Forms Applications
The Forms Designer
Designer Menu
Using Modules
Storing Modules on the Database
The Object Navigator
- Creating, Deleting, Moving & Copying Objects
The Layout Editor
Setting Visual Attributes
Using the Drawing Options
Using Colour Palettes
The Properties Window
Property Classes
Visual Attributes
The Menu Editor
Creating, Deleting & Moving Menus and Menu Items
Forms Objects
Blocks & Relations
Items
Generic Property items.
Text Items and Display Items.
Events
Controls
Push Buttons
Radio Groups & Buttons
Check Boxes
List Boxes
Windows & Dialogue Boxes
Alerts
Canvas Views
Record Structures & Other Objects
Records
Record Groups
Lists of Values
Menus and Toolbars
To book call 0800 028 6400
Oracle Forms Course UK