Oracle Forms 9i

In this hands-on course, students will rapidly build form applications using wizards and other productivity features of Oracle Forms.  The appearance of the form will be customized using the layout editor and PL/SQL code will be written to enhance the default form behavior.  Customized menu bar modules and PL/SQL library modules will be discussed and uilized.

 

Class Agenda:

  • Creating and modifying forms using the wizards
    • Data block wizard
    • Layout wizard
    • List of Values (LOV) wizard
  • Understanding forms runtime
    • Performing queries
    • Using the form to insert, update and delete data
  • Using the Object Navigator
  • Invoking and using property palettes
  • Customizing form appearance using the layout editor
  • What are Form Items?
    • Text items
    • Formula or Summary items
    • Display items
    • Check boxes
    • Radio groups and radio buttons
    • List items
    • Buttons
  • Client-side triggers
  • Forms Built-Ins
    • Procedures and functions
    • System variables
  • Using the PL/SQL editor
  • Other Form Objects
    • Visual attributes
    • Relationships
    • Alerts
    • LOVs and record groups
    • Canvases and windows
  • Building custom menu modules

Prerequisites:

  • Oracle 9i SQL Fundamentals, Oracle PL/SQL Fundamentals or equivalent experience

Audience:

  • Oracle application developers

Course Benefits:

  • Students will be able to create and modify form, menu and PL/SQL library modules using Forms Builder.

Materials Furnished:

  • Student Manual

Recommended Follow-On Course:

  • Oracle Reports 9i
  • Oracle 9i Advanced SQL
  • Oracle 9i Advanced PL/SQL

Course Length: Five Days

List Price: $2495