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)
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
|
|
|