	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

Oracle Forms Workshop

Click here to contact us

Course Overview

Oracle Forms Workshop provides students with the knowledge necessary to develop and deploy GUI database applications in a Web browser. Through extensive hands-on exercises, students will learn how to use Oracle Forms Developer to develop database applications. The focus for this five-day class is building an application to run a business. Using intensive exercises, students will create a finished application that incorporates many of the advanced design features needed to solve complex business problems. Instruction will include building applications using both the available wizard tools and a more in-depth manual approach. By learning both methods, students are assured of a thorough understanding of the inner complexities of the tool set. Also included in the class are tips and design techniques to ensure a successful implementation of an Oracle Forms application.

Course Goals

To understand product capabilities and features
To understand product structure and commands
To acquire skills for development and customization of Oracle Forms applications

Prerequisites

SQL & SQL*Plus
PL/SQL
Advanced PL/SQL (optional)

Who Should Attend?

All developers beginning a GUI application

Course Materials

Oracle Forms Course Notes
Oracle Forms Reference Publication
Oracle Forms Sample Script and Examples Disk

Duration

Five days

Tuition

$2,325

Course Outline

Class environment
10g new features
Forms designer
- Forms designer installations
- Architecture
Forms basics and terminology
- Object navigator
- Building a form
- Running a form
Dissecting the form
- Cursor navigation
Parts of a form
- Property palette
- Form properties
- Block properties
- Frame properties
- Item properties
- Bookmarking
- Interface items
Layout editor
- Departments form
Controlling look and feel
- Visual attributes
- Using VAGs
- Property classes
- Property class properties
- Inheritance
Working in multiple forms
- Sharing attributes
- Object groups
- Object libraries
- Smart classes
Interface items
- Check box
- List item
- Radio groups
List of values
- Record groups
- List of values
- LOV wizard
Windows, canvases and views
- Windows
- Canvases
- Window demo
- Product form
- Highlighting
Forms compiler
Adding functionality
- Buttons
- Main menu form
- Events and triggers
Events and triggers
- Interface events
- Keyboard events
- Internal processing events
- Trigger scope
- Creating triggers
- PL/SQL syntax palette
Built-ins
Triggers
- Trigger categories
- Block processing triggers
- Interface event triggers
- Navigation triggers
- Transaction triggers
- Query triggers
- Message triggers
- Master-detail triggers
- Key triggers
Referring to forms objects
- Block objects
- System variables
- Global variables
- Parameters
Timers
- Using timers
Using images
- Employees form
- Image items
Sharing code
- Duplicating code
- Program units
- PL/SQL libraries
Error handling
- PL/SQL errors
- Debugging
Validation
- Forms validation
- Blocks, records and items
Alerts
- Using alerts
- Dynamic alerts
Master-detail relationships
- Sales form
- Relationships
Calculation items
Menus
- Menu editor
- Forms menus
Advanced forms techniques highlights
- Java integration
- Security