Oracle Forms Workshop

 Click here

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

• Introduction to SQL
• Advanced SQL
• PL/SQL
• Advanced PL/SQL (optional)

Who Should Attend?

• All developers beginning a GUI application

Course Materials

• Oracle Forms Course Notes

Duration

• Five (5)days

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