TUSC Services
Oracle Applications Consulting E-Business Suite
 Oracle Business Intelligence Consulting Business Intelligence
 Project Management and Implementation Support Custom Development
 Oracle Database Consulting Database Services
 Remote DBA Support and Oracle DBA TroubleshootingManaged (DBA) Services
Oracle TrainingTraining/Mentoring
Oracle Software Licensing Oracle Licensing

Oracle Forms Workshop

Oracle Training 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

  • $1,995

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