Oracle Developer/2000: Advanced Forms Development

In this 3 day instructor led class, students will be able to develop complex Oracle Forms and will use Project Builder to manage multiple transactions. Students will also learn how to include custom menus, reports, and charts in a form.

Prerequisites: Before taking this course, student should have at least six months of experience using SQL and PL/SQL in Forms.

Benefits: After taking this course, students will be able to create essential Forms, develop an application using Forms, and know how to create application with advanced features.

Target student: Students enrolling in this course should know SQL & PL/SQL. This course is intended for people who aspire to become Oracle Developers. In addition, it is beneficial for those who will work as project managers for Oracle Projects, as well as for application support personnel.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Create, Modify, and Attach a Menu to a Form
  • Program Function Keys and Define Mouse Events
  • Manage Windows and Canvases Using Form Builder Built-ins
  • Compare the Different Types of Data Sources
  • Control Data Block Relationships in Master-Detail Forms
  • Implement Multiple Form Applications using Form Builder Built-ins
  • Create Different Types of Record Groups
  • Integrate Charts and Reports Within Oracle Forms
  • Control Forms Using Timers
  • Use Oracle8i Server Features in Oracle Forms Applications
  • Use Reusable Components Available in Form Builder
  • Manage Oracle Applications Using Project Builder

Hardware/software required to run this course

  • Oracle8i Personal Edition
  • Developer 2000 Release 2.1
  • Pentium II 266
  • 128 MB of RAM
  • 4-GB of Free Hard Disk Space
  • 256K cache
  • 4X CD-ROM drive
  • Network Adapter
  • SVGA Monitor
  • Mouse or compatible pointing device
  • Sound card

Class Outline

Lesson 1: Working with Menus

  • Designing Menus
  • Using Pop-up Menus
  • Managing and Customizing Menus

Lesson 2: Using Key and Mouse Triggers

  • Responding to Function Keys
  • Responding to Mouse Events

Lesson 3: Controlling Windows and Canvases

  • Window Triggers
  • Manipulating Windows Programmatically
  • Manipulating Canvases Programmatically

Lesson 4: Controlling Master/Detail Blocks

  • Master/Detail blocks
  • Relation-Handling Code

Lesson 5: Data Block Sources

  • Stored Procedures
  • Other Data Block Sources

Lesson 6: Building an Application with Multiple Forms

  • Different Ways to Invoke Forms
  • Managing Multiple Forms
  • Passing Data Between Forms

Lesson 7: Working with Record Groups

  • Creating Record Groups
  • Building List-items and LOVs Dynamically

Lesson 8: Including Reports and Charts in a Form

  • Creating and Invoking a Report
  • Including a Chart in a Form Module

Lesson 9: Applying Timers

  • Creating a Timer
  • Modifying a Timer

Lesson 10: Using Server Features

  • Partitioning PL/SQL Program Units
  • Handling Errors
  • Executing DDL Commands

Lesson 11: Applying Reusable Components

  • Introducing the Reusable Components
  • Applying the Calendar Class

Lesson 12: Managing Oracle Applications Using Project Builder

  • Introducing Project Builder
  • Using Project Builder
  • Packaging a Project for Delivery

Appendix A: The Gifts Online Business Model

  • Narrative of the Gifts Online Business Model
  • The Entity Relationship Diagram for Gifts Online
  • Table Descriptions for the Gifts Online Business Model
  • Table Data for the Gifts Online Business Model

To Hire a proven Oracle Forms Subject Matter Expert Consultant and Instructor who teaches this class, call 800-798-3901 today!

Leave a Reply