|
Provided by: 123-CBT Computer Based Training Oracle Form Builder Handling Multiple Object Relationships |
 |
Training
Provided by 123-CBT Computer Based Training
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 60111, 60112 and 60113. 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.
|
|
||||||||||
Oracle Form Builder Handling Multiple Object Relationships
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
