Oracle Developer: Enhancing the User Interface

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 part of the Oracle Developer series Oracle Developer: Forms Fundamentals (62211).

• Create input and noninput items.
• Identify the features and uses of LOVs.
• Create LOVs manually and using the LOV Wizard.
• Create and use editors.
• Create and set properties for a window and a content canvas.
• Create and set properties for stacked toolbar and tab canvases.
• Identify trigger events components and execution hierarchy.
• Create triggers and identify elements of trigger code.
• Add functionality to triggers using builtins.
• Add functionality to input items by creating triggers containing builtins.
• Add functionality to noninput items by creating triggers containing builtins.

Unit 1: Items: Creating

• Identify input item types.
• Identify non-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 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 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 by using the Property Palette.
• 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 item based on a formula by setting calculation-specific properties.
• Create a calculated item based on a summary by setting calculation-specific properties.
• Identify methods for creating a hierarchical tree item.

Unit 2: LOVs and Editors

• Identify the objects required to design an LOV.
• Create an LOV by using the LOV Wizard.
• Create an LOV manually by using the Create icon in the Object Navigator.
• Attach an LOV to a text item by using the Property Palette.
• Customize an LOV by setting associated properties.
• Create a customized editor by using the Create icon in the Object Navigator.
• Attach an editor to a text item by using the Property Palette.

Unit 3: Windows and Canvases

• Match the display objects with the appropriate definition.
• 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 the tab canvas-related properties by using the Property Palette.

Unit 4: Form Builder Triggers

• Identify the types of events that fire a trigger.
• Identify the trigger type given a description.
• Identify the scope of a trigger based on its placement in the object hierarchy.
• Identify the statements that are allowed in trigger code.
• Identify the default setting of the execution hierarchy property of a trigger.
• Create a trigger by using an appropriate method.
• Match the PL/SQL Editor component with the appropriate description.
• Match the trigger property with the appropriate description.
• Identify the rules for writing trigger code.
• Identify Form Builder variable types.
• Match the standard built-in subprogram name with the appropriate description.
• Copy a built-in name and arguments into existing code.

Unit 5: Items: Adding Functionality

• Enhance the functionality of a radio group by creating a When-Radio-Changed trigger.
• Enhance the functionality of a check box by creating a When-Checkbox-Changed trigger.
• Identify built-ins used to enhance the functionality of a list item.
• Display an LOV from a button by creating a trigger containing the SHOW_LOV built-in.
• Populate an image item with an image by creating a trigger containing the READ_IMAGE_FILE built-in.
• Identify built-ins used to manage the components of a sound item control.
• Identify built-ins used to populate a hierarchical tree item.

8

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

CDROM
Web Based Training