• Database Administrators
• Technical Support Professionals
• Application Developers
• Designer/Developers

Required Prerequisites:

None

Suggested Prerequisites:

None

Course Objectives:

• 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.
• nvoke multiple forms by using built-ins and pass data between forms by using parameter lists.
• Control list items at design time and programmatically by using built-in functions.

Key Triggers and Mouse Events

• 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.

Window and Canvas: Runtime Management

• 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.

Data Block Relationships

• 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.

Working with Multiple Form Applications

• 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.

Record Groups and List Items

• Identify the uses of record groups.
• 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.
• 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.

Form Builder Triggers

• Identify the events that invoke a trigger.
• Identify the trigger type given their description.
• Match the scope of a trigger with their description.
• Identify the statements that are allowed in trigger code.
• Match the execution hierarchy of a trigger with their description.
• Create a trigger by using an appropriate method.
• Match the PL/SQL Editor components with their description.
• Match the trigger properties with their descriptions.

Match the Form builder variable name with their type.

• Match the standard built-in subprogram names with their descriptions.
• Copy a built-in name and argument in an existing code.

Adding Functionality

• Create a trigger to add functionality to a radio group.
• Add functionality to a check box by creating a trigger containing the CHECKBOX_CHECKED built-in.
• Add functionality to a List Item by creating a trigger containing built-ins.
• Display LOV from a button by creating a trigger containing the SHOW_LOV built-in.
• Identify the built-ins that can be used to hide or display or get information about each component of a sound item control programmatically.

Please check with your Education Representative to determine the appropriate follow up course.

No related Interactive Courseware is currently available.