The Developer/2000: Build Forms II Curriculum consists of the following courses:

Oracle Form Builder: Managing Module Types
Oracle Form Builder: Handling Multiple Object Relationships
Oracle Form Builder: Including Reusable Oracle Components

Course Overview

Learn To:

• Identify the benefits and terminology of Project Builder.
• Create a project.
• Establish dependencies.
• Deliver a project.
• Create a menu module containing menus, menu items, menu toolbars, and pop-up menus in Form Builder.
• Manage a menu module by control.
• Customize and implement security by using built-ins and substitution parameters.

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 three parts of the Oracle Form Builder series, courses 61211, 61212, and 61213.

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Identify the benefits of using Project Builder.
• Match the terms used in Project Builder with their definitions.
• Create a connection in Project Builder by using the pop-up menu.
• Create an empty standalone project using the Project Wizard.
• Add files to an empty project using Project Wizard.
• Identify the operations that are possible using the Project Builder.
• Establish explicit dependency in a project using Project Builder.
• Build dependencies in Projects by using the Project Builder compile options.
• Deliver a project using the Project Builder.
• Identify the items from which an entry can inherit properties.
• Create a new file type in the Project Builder by using the Default Menu.
• Match the Project Builder action types with their features.
• Modify a type by adding actions using the pop-up menu.
• Match the types of macros with their descriptions.
• Create a macro in a project by using the pop-up menu.
• Customize the Launcher by using the Project Builder default menu.

• Match components of the Menu Module with their functions.
• Match the menu styles in Form Builder with their menus they display.
• Match the components of Menu Editor toolbar with their functions.
• Create a Menu Module by using the Menu Editor.
• Match the menu Module properties with their functions.
• Match the menu properties with their functions.
• Match the menu item properties with their functions.
• Manipulate the menu item properties to change the appearance and behavior of a menu item by using the Property Palette.
• Create a Menu Toolbar by using the Property Palette visible in the horizontal Menu Toolbar visible in the vertical Menu Toolbar.
• Attach the Menu Module to a Form Module by using the Property Palette.
• Create a pop-up menu in a Form Module.

• Identify the methods by which a form module and a menu module share code.
• Match the menu item built-ins with their functions.
• Replace the current menu in a form module by using the REPLACE_MENU built-in.
• Match the predefined substitution parameters with their descriptions.
• Create a user-named substitution parameter from the Form Builder Object Navigator.
• Reference a substitution parameter by using the QUERY_PARAMETER built-in.
• Validate a substitution parameter value by using the QUERY_PARAMETER built-in.
• Sequence the steps to implement menu security in a form module.
• Assign a role to a menu module by using the Menu Module Property Palette.
• Assign access to a menu item by using the Menu Editor.

Course Overview

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.

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

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

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

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

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

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

Course Overview

Learn To:

• Implement the methods to use additional data sources on which to base data blocks.

 
• Include charts, reports, and timers in Forms modules by using wizards and built-ins.

 
• Understand the concepts behind reusability and procedures to reuse components, objects, and code.

 
• Implement the new Oracle Server error handling features accessible to Form Builder.

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 five parts of the Oracle Form Builder series, courses 61211, 61212, 61213, 61214 and 61215.

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Identify the types of data sources used for performing database operations on data blocks.
• Base a data block on a FROM clause query by using the Property Palette.
• Write the code to base a data block on a stored procedure that returns a Ref cursor.
• Write the code to base a data block on a stored procedure that returns a table of records.
• Identify the properties of a data block based on a stored procedure.
• Identify the performance implications specific to database calls using a particular data access mechanism.
• Identify the guidelines to base a data block on a stored procedure.
• Identify the restrictions on performing database operations on data source objects.

• Create a chart item in a Form module by using the Chart Wizard.
• Identify the type of a chart on the basis of its appearance.
• Identify the properties of Chart Items.
• Create a report object based on a data block in a Form module by using the Report Wizard.
• Identify the properties of Report Object.
• Identify the built-ins used to programmatically control reports in a Form module.
• Write the code to run a report against a local server by using built-ins.
• Write the code to run a report against a remote server by using built-ins.
• Identify the built-ins for timers.
• Identify the features of the When-Timer-Expired trigger.
• Write the code to manage timers by using built-ins.
• Sequence the steps involved in managing expired timers.

• Identify the benefits of reusing objects and code.
• Create a Property class with properties by using the Object Navigator.
• Create a Property Class by using the Property Palette.
• Set the properties of an object by using a named Property class.
• Create a populated Object Group by using the Object Navigator.
• Copy an object in a Form Builder application.
• Identify the features of subclassed objects.
• Reuse an object by using subclassing.
• Create an object library by using the Object Navigator.
• Populate a Form Builder module with objects from an object library.
• Identify the methods to reuse PL/SQL in subprograms.
• Identify the features of PL/SQL libraries.
• Write the code to accept a reference to bind a module variable of local scope in PL/SQL library subprogram by using the IN and INOUT parameters.
• Populate a PL/SQL library module with objects by using different methods.
• Attach a PL/SQL library to form module by using the Attach Library dialog box.
• Write the code to reference a library program unit within an attached library in a form module trigger by using a variable.
• Identify the included reusable components in Form Builder.
• Create a calendar in a form module by using the Calendar object group in the Standard Object Library.
• Write the code to manipulate the calendar at run-time by using the Date_LOV.Get_Date built-in in the Calendar.pll attached library.
• Create a picklist in a form module by using the Picklist object group in the Standard Object Library.
• Display a populated picklist by using Form Builder built-ins.

• Identify the features available in Form Builder to handle possible errors.
• Identify the order of preference for the location of PL/SQL code.
• Identify the features of error messages caused by failed Form Builder calls to the Oracle Server.
• Match the predefined error messages with the DML declarative constraint violations that generate them.
• Complete the code for the ON-ERROR trigger to display error information caused by an implicit call to the Oracle Server.
• Complete the code to display error information caused by an explicit call to the Oracle Server.
• Complete the code to dynamically perform database operations by using FORMS_DDL.

Click here for Secure Yahoo Order: Developer/2000: Build Forms II Curriculum

Get Train in Oracle
Oracle Training CBT

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