Computer Courses

ORACLE FORMS 6i/10g/11g

Oracle Forms is creating screens that interact with an Oracle database. It has an IDE including an object navigator, property sheet and code editor that uses PL/SQL. It was originally developed to run server-side in character mode terminal sessions. It was ported to other platforms, including Windows, to function in a client–server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java and web services.

Duration:
Programs Hours
Oracle Forms 6i/10g/11g 20
Objectives
After completing this course, you should be able to do the following:
  • Create form modules including components for database interaction and GUI controls.
  • Display form modules in multiple windows and a variety of layout styles.
  • Test form modules in a Web browser.
  • Debug form modules in a three-tier environment
Implement triggers to:
  • Enhance functionality
  • Communicate with users
  • Supplement validation
  • Control navigation
  • Modify default transaction processing
  • Control user interaction
  • Reuse objects and code
  • Link one form module to another

Course Content:

Day 1
  • Lesson 1: Introduction to Oracle Forms Developer and Oracle Forms Services
  • Lesson 2: Running a Forms Builder Application
  • Lesson 3: Working in the Forms Developer Environment
  • Lesson 4: Creating a Basic Form Module
  • Lesson 5: Creating a Master-Detail Form
  • Lesson 6: Working with Data Blocks and Frames
Day 2
  • Lesson 7: Working with Text Items
  • Lesson 8: Creating LOVs and Editors
  • Lesson 9: Creating Additional Input Items
  • Lesson 10: Creating Noninput Items
Day3
  • Lesson 11: Creating Windows and Content Canvases
  • Lesson 12: Working with Other Canvas Types
  • Lesson 13: Introduction to Triggers
  • Lesson 14: Producing Triggers
  • Lesson 15: Debugging Triggers
Day 4
  • Lesson 16: Adding Functionality to Items
  • Lesson 17: Run-time Messages and Alerts
  • Lesson 18: Query Triggers
  • Lesson 19: Validation
  • Lesson 20: Navigation
Day 5
  • Lesson 21: Transaction Processing
  • Lesson 22: Writing Flexible Code
  • Lesson 23: Sharing Objects and Code
  • Lesson 24: Using WebUtil to Interact with the Client
  • Lesson 25: Introducing Multiple Form Applications