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

Oracle Form Builder: Forms Fundamentals
Oracle Form Builder: Enhancing the User Interface
Oracle Form Builder: Writing and Debugging Code

Course Overview

Learn To:

• Identify the key features, components and capabilities of Developer/2000.

 
• Identify the features of the Form Builder environment.

 
• Run and create a basic form module.

 
• Customize a form module.

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.

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Identify the features of Developer/2000.
• Match the components of Developer/2000 with the tasks that they enable.
• Identify the common features of Developer/2000 Components.
• Identify the features of Oracle Toolkit.
• Identify the features of the Developer/2000 main menu.
• Set preferences to customize a Developer/2000 session by using the Preferences dialog box.
• Match the main environment variables with their descriptions.
• Identify the tasks that various Form Builder executables enable.
• Match each Form Builder module type with its corresponding description.
• Identify the descriptions of the main components of a Form Module.
• Identify the features of the Form Builder block types.
• Match each Form module object type with its description.

• Match the components of the Form Builder runtime environment with their features.
• Match the different methods for navigating the Form Builder Runtime with their features.
• Identify the tasks that can be performed in the two modes of Forms Runtime operation.
• Perform an unrestricted query by using the default functionality.
• Perform a restricted query by using the Query Where dialog box.
• Insert a record by using the default functionality.
• Update a record by using default functionality.
• Delete a record by using the default functionality.
• Make changes permanent by using the menu option.
• Display runtime errors by using the help option.
• Exit a runtime session by using the menu option.
• Using a specified option, create a new form module by invoking the Form Builder Wizard.
• Create a new form module in a Form Builder component by using a given method.
• Set the properties of a form module in the Object Navigator by using the Property Palette.
• Identify the features of the Form Builder wizards.
• Create a new data block by using the Data Block Wizard.
• Modify a layout of a data block by using the Layout Wizard in reentrant mode.
• Deliver a form module based on given specifics.
• Match the module type extensions with their storage format.
• Identify and create a master-detail relationship.
• Identify the definition of a master-detail relationship.
• Create a master-detail form module by using the Data Block Wizard.

• Match the component names with their components in the Property Palette.
• Create a visual attribute in the Object Navigator by using the Create icon.
• Modify the properties that control the behavior of a data block by using the Property Palette.
• Modify the properties that control the appearance of a data block by using the Property Palette.
• Modify the frame properties of a data block by using the Property Palette.
• Set properties on multiple objects by using the Property Palette.
• Create a control block in the Object Navigator by using the Create icon.
• Delete a data block in the Object Navigator by using the Delete icon.
• Create a text item in a builder component by using a specific method.
• Modify the appearance of a text item by using the Property Palette.
• Modify the properties that control the data of a text item by using the Property Palette.
• Modify the properties that enhance the relationship between text item and database by using the Property Palette.
• Modify the properties that add functionality to a text item by using the Property Palette.
• Modify the properties that alter the navigational behavior of a text item by using the Property Palette.
• Modify the properties that provide context sensitive help by using the Property Palette.

Course Overview

Learn To:

• Create input and non-input items.

 
• Create Lists of Values (LOVs) and Editors that are Form Builder objects to supplement the text item object.

 
• Create and set properties for Windows and Canvases.

 
• Identify the events associated, components, and execution hierarchy of triggers.

 
• Add functionality to input and non-input items by creating triggers containing built-ins.

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 part of the Oracle Form Builder series: Course 61211, Oracle Form Builder: Forms Fundamentals.

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Identify and create input items.
• Identify the input item types.
• Create a check box in the Layout Editor by using the Check Box tool.
• Convert an existing item into a check box in the Layout Editor by using the Property Palette.
• Create a list item in the layout Editor by using the List Item tool.
• Convert an existing item into a list item in the Layout Editor by using the Property Palette.
• Create a radio group item in the Layout Editor by using the Radio Button tool.
• Convert an existing item into a radio group item in the Layout Editor by using the Property Palette.
• Identify non-input item types.
• Create a display item in the Layout Editor by using the Display Item tool.
• Create an image item in the Layout Editor by using the Image Item tool.
• Create a sound item in the Layout Editor by using the Sound Item tool.
• Create a button in the Layout Editor by using the Button tool.
• Create a calculated field based on a formula by creating a new item using the Create icon in the Object Navigator.
• Create a calculated field based on a summary by creating a new item using the Create icon in the Object Navigator.

• Create and attach LOVs and Editors.
• Identify the features of LOVs.
• Identify the objects required to design a LOV.
• Identify the uses of record groups.
• Create a LOV by using the New LOV dialog box.
• Set LOV properties by using the Property Palette.
• Attach a LOV with a text item by using the Property Palette.
• Create a customized editor by using the Create icon in the Object Navigator.
• Attach an editor with a text item by using the Property Palette.

• Match the display objects with their definitions.
• Match the types of windows with their features.
• Identify the definition of a content canvas.
• Identify the benefits of creating a new window.
• Create a new window by using the Create icon in the Object Navigator.
• Set the window object properties by using the Property Palette.
• Create a content canvas by using the Create icon in the Object Navigator.
• Set the Window property of a content canvas by using the Property Palette.
• Create a stacked canvas by using an appropriate method.
• Set the stacked canvas properties by using the Property Palette.
• Check the display position of a stacked canvas in the Layout Editor.
• Create a toolbar canvas by using the Object Navigator.
• Set the toolbar canvas-related properties by using the Property Palette.
• Create a tab canvas by using an appropriate method.
• Set tab canvas-related properties by using the Property Palette.

• 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.
• Identify the rules for writing trigger code.
• 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.

• 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.
• Display an image in an image item by creating a trigger containing the READ_IMAGE_FILE 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.

Course Overview

Learn To:

• Identify the descriptions of the communication formats used by Form Builder.

 
• Write codes to detect errors, suppress system messages, create alerts, and control alerts at runtime.

 
• Run a form module in Debug mode.

 
• Identify the concepts related to debugging a PL/SQL code.

 
• Debug a PL/SQL code.

 
• Identify the process involved in querying a data block.

 
• Write triggers to query a data block.

 
• Manipulate the query process.

 
• Perform validation and navigate within a form by using triggers and built-ins.

 
• Identify the concepts related to transaction processing.

 
• Customize a Form Builder application by writing different types of commit triggers and overriding the default transaction processing.

 
• Write a flexible code by using system variables and built-ins and by referencing objects directly or indirectly.

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

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Match the communication formats used by Form Builder with their descriptions.
• Write the code for detecting an error by using built-ins.
• Write the code to control system messages by using system variables.
• Write the code to explicitly fail a trigger by using the FORM_TRIGGER_FAILURE exception.
• Identify the uses of the Error triggers.
• Create an alert by using the Create icon in the Object Navigator.
• Write the code to control an alert at runtime by using the built-in sub programs.

• Run a form module in the Debug mode by using the Debug Mode toolbar button in the Object Navigator.
• Match the PL/SQL Debugger components with the tasks that they enable.
• Set a breakpoint in code by using the Source pane of the Forms Debugger window.
• Identify the user-defined debug actions that occur automatically during debugging.
• Match the debug commands with their functions.
• Debug PL/SQL code to identify the cause of an error by using the Forms Debugger window.

• Sequence the events that take place when a query is initiated on a data block.
• Identify the sources for the different clauses of the default SELECT statement.
• Write the code for a Pre-Query trigger at the data block level.
• Write the code for a Post-Query trigger at the data block level.
• Implement query array processing in a Form Builder application.
• Write a code for a trigger to fire in the Enter Query mode by using the SYSTEM.MODE variable.
• Match the transactional triggers that override default query processing in Form Builder with their characteristics.
• Match the block properties with the associated built-ins that can be used to manipulate query information.

• Sequence the steps of the validation process used by Form Builder.
• Set the Validation Unit property of a form by using the pop-up menu.
• Validate a value entered in an item by using a List Of Values (LOV).
• Write the code for a trigger to validate user inputs at different levels.
• Match the built-ins for validation with their functions.
• Sequence the Form Builder navigation units according to their navigation hierarchy.
• Match the navigation properties with their characteristics.
• Match the navigation trigger types at different levels with their uses.
• Write the code for the When-New-Object-Instance trigger at different levels.
• Specify the built-ins used for navigation, given their functions.

• Identify the events that take place during the different phases of transaction processing.
• Sequence the events that take place during commit processing.
• Match the different types of commit triggers with the conditions under which they fire.
• Match the different types of commit triggers with their common uses.
• Write a Pre-Delete trigger to implement a validation before the deletion of a row.
• Write a Pre-Insert trigger to assign sequence numbers to records.
• Write a Post-Update trigger to record audit information about the changes applied to base tables.
• Write the code to test the result of a DML operation in a trigger by using the attributes of PL/SQL implicit cursors.
• Identify the rules followed by Form Builder while issuing DML statements during commit processing.
• Write an On-Logon trigger to override the default logon process.
• Identify the different ways to run Form Builder against non-Oracle data sources.
• Match the commit status values returned by different system variables with their implications.
• Write the code to manipulate the commit status of a record by using built-ins in the code.
• Implement array DML processing in a Form Builder application.

• Identify the benefits of writing flexible code.
• Write the code to determine which block should have the input focus by using system variables in the code.
• Write the code to perform an action based on the status of the current block by using system variables in the code.
• Write the code to obtain information about the current application by using the GET_APPLICATION_PROPERTY built-in.
• Write the code to modify the properties of an item in the current application by using the SET_ITEM_PROPERTY built-in.
• Identify the benefits of referencing objects by using their object IDs.
• Reference an object within the initial PL/SQL block by using its internal ID.
• Reference a local object outside the initial PL/SQL block by using its internal ID.
• Identify the characteristics of the built-in subprograms used to indirectly refer to objects.

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

Get Train in Oracle
Oracle Software Training

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