Oracle SQL

Oracle PL/SQL

Oracle Forms

Oracle Reports

Residential Courses

Prices

Location

Oracle Form Builder: Handling Multiple Object Relationships
Computer based training course

Course ID: 61215

Course Overview

This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items.

Learn To:

• Identify the rules, types, and functions of Key triggers.
• Write an application that responds to mouse events.
• Write the codes to manage windows and canvases by using built-ins and triggers.
• Create and modify relations between two associated blocks by using Object Navigator and programmatic control.
• Invoke multiple forms by using built-ins and pass data between forms by using parameter lists.
• Work with record groups.
• List items at design time and programmatically by using built-in functions.

Content Emphasis

Skills-Based

Audience

Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 61111, 61112 and 61113. In addition, participants should have taken the first four parts of the Oracle Form Builder series, courses 61211, 61212, 61213, and 61214.

Total Learning Time

7 - 8 Hour(s)

Course Contents

Unit 1: Key Triggers and Mouse Events

Duration: 2 Hour(s)

• Create a Key trigger in a form module by using PL/SQL Editor.
• Identify the rules for defining Key triggers.
• Match the types of key triggers with their descriptions.
• Identify the functions of key triggers in a form module.
• Type in the PL/SQL code to associate a built-in with the DO_KEY built-in.
• Match the mouse system variables with their functions.
• Specify the mouse movement trigger for a specific function.
• Create a mouse button action trigger for a specified task by using PL/SQL Editor.
• Identify the guidelines to follow while implementing the drag-and-drop functionality.

Unit 2: Window and Canvas: RunTime Management

Duration: 2 Hour(s)

• Match the window-interaction triggers with their characteristics.
• Match the built-ins used for manipulating windows with their functions.
• Write the code to change the appearance of a window in a form by using built-ins.
• Write the code to display multiple windows at specified positions in a form by using the built-ins.
• Write the code to close a window by using built-ins.
• Match the built-ins for manipulating canvases with their functions.
• Write the code to manipulate tab-style canvases by using built-ins.

Unit 3: Data Block Relationships

Duration: 1 - 2 Hour(s)

• Create an explicit relation between two associated blocks by using the New Relation dialog box.
• Modify the delete behavior between related blocks by using the relation Property Palette.
• Modify the query coordination behavior between related blocks by using the relation Property Palette.
• Identify the block-coordination phases in a relation.
• Identify the features of the default relation-handling triggers.
• Match the default relation-handling procedures with the triggers that call them.
• Write the code to implement the coordination-type toggle between blocks by using built-ins.
• Write the code to implement the coordination-type toggle between blocks by using built-ins.

Unit 4: Working with Multiple Form Applications

Duration: 1 Hour(s)

• Identify the behavior of a multiple form application.
• Identify the methods by which multiple form modules in an application share information.
• Identify the built-ins used to programmatically invoke another form module.
• Write the code to invoke a form module in a modeless fashion by using a built-in.
• Write the code to perform a query at form startup by using a trigger.
• Match the built-ins used for navigating forms with their descriptions.
• Identify the features of transaction processing for opened form modules.
• Write the code to call a form module in a modal fashion from an open form module by using the built-in.
• Write code to modify the default functionality of transaction processing for called forms.
• Write the code to invoke a new form after exiting the current form by using a built-in.
• Identify the restrictions on using OPEN_FORM with CALL_FORM.
• Match the various methods of invoking forms with the tasks they enable you to perform.
• Create a form parameter by using the Object Navigator.
• Match the built-ins used for manipulating parameter lists with their functionality.
• Write the code to pass data between forms by using the form parameters.
• Write the code to close a form by using the CLOSE_FORM built-in.
• Write the code to close a form by using the EXIT_FORM built-in.

Unit 5: Record Groups and List Items

Duration: 1 Hour(s)

• Identify the uses of record groups.
• Match the record group types with their functionality.
• Create a query record group at design time by using the Object Navigator.
• Create a static record group at design time by using the Object Navigator.
• Modify a record group at design time by using the Property Palette.
• Match the built-ins used to manage the record group structures with their functionality.
• Identify the built-ins used to manage the data in record groups.
• Match the built-ins used to process record group rows with their functionality.
• Identify the built-in functions that are used to search for record group objects.
• Define a query record group by using built-ins.
• Define a non-query record group by using built-ins.
• Write the code to manipulate record group rows by using built-ins.
• Write the code to manipulate selected record group rows by using built-ins.
• Identify the built-ins used for manipulating list items.
• Write the code to implement dynamic list item by using built-ins.
• Write the code to add values to a combo box list item at runtime by using built-ins.

Anglesey has over 125 miles of coastline designated "areas of Natural Outstanding Beauty".

Tyn Y Felin is a mere five minutes away from the A55 North Wales Coast Expressway and is a perfectly situated coastal retreat on the serene and beautiful Isle of Anglesey.