Course Overview

Learn To:

• Identify the rules, types, and functions of Key triggers.
• Create a Key trigger and write the code that associates the key triggers with the user interface.
• Write code that responds to mouse events.
• Write the code to manage windows and canvases by using built-ins and triggers.
• Invoke multiple forms by using built-ins and pass data between forms by using parameter lists.
• Work with record groups.
• Control list items at design time and programmatically by using built-in functions.

Skills-Based

Audience

Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first four parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals (62211); Oracle Developer: Enhancing the User Interface (62212); Oracle Developer: Writing and Debugging Code (62213); and, Oracle Developer: Project Builder and Menu Modules (62214).

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Match the types of Key triggers with their descriptions.
• Identify the uses of Key triggers in a form module.
• Identify the rules for defining Key triggers.
• Create a Key trigger in a form module by using the PL/SQL Editor.
• Associate a built-in with the DO_KEY built-in by using the PL/SQL Editor.
• Match the mouse related triggers with their events.
• Create a mouse movement trigger by using the PL/SQL Editor.
• Create a mouse button action trigger for a given task by using the PL/SQL Editor.
• Match the mouse system variables with their uses.
• Identify the guidelines to follow while implementing the drag-and-drop functionality.

• Match the window-interaction triggers with their functions.
• 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 built-ins.
• Write the code to close a window by using built-ins.
• Identify the characteristics of windows and blocks in a form.
• Match the built-ins for manipulating canvases with their functions.
• Write the code to manipulate tab-style canvases by using built-ins.

• Identify the behavior of a multiple form application.
• Identify the methods to share information between multiple forms.
• Identify the built-ins used to programmatically invoke another form.
• Match the different methods of invoking forms with the tasks they enable you to perform.
• Write the code to invoke a form in a modeless fashion by using built-ins.
• Write the code to perform a query at forms startup by using triggers.
• Match the built-ins for navigating forms with their descriptions.
• Identify the features of transaction processing for Opened Forms.
• Write the code to invoke a form in a modal fashion from an open form by using built-ins.
• Modify the default functionality of transaction processing for called forms by using the PL/SQL Editor.
• Write the code to invoke a new form on exiting the current form by using built-ins.
• Identify the restrictions on using OPEN_FORM with CALL_FORM.
• Match the different methods of invoking forms with the tasks they enable you to perform.
• Create a form parameter by using the Object Navigator.
• Write the code to pass data among forms by using parameter lists.
• 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.

• 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.
• Define a query record group by using built-ins.
• Define a non-query record group by using built-ins.
• Match the built-ins used to process record group rows with their functionality.
• 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 items by using built-ins.
• Write the code to add values to a combo box list item at run time by using built-ins.

Click here for Secure Yahoo Order: Oracle Form Builder R6: Controlling the User Interface Programmatically

Get Train in Oracle
Oracle Training CBT

Best Regards,
Oracle Database, SQL, Application, Programming Tips