Oracle SQL

Oracle PL/SQL

Oracle Forms

Oracle Reports

Residential Courses

Prices

Location

Oracle Form Builder: Enhancing the User Interface
Computer based training course

Course ID: 61212

Course Overview

This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them.

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.

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 61111, 61112 and 61113. 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

Unit 1: Creating

Duration: 2 Hour(s)

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

Unit 2: LOVs and Editors

Duration: 2 Hour(s)

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

Unit 3: Windows and Canvases

Duration: 1 - 2 Hour(s)

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

Unit 4: Form Builder Triggers

Duration: 1 Hour(s)

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

Unit 5: Adding Functionality

Duration: 1 Hour(s)

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

Anglesey has over 125 miles of coastline designated "areas of Natural Outstanding Beauty".

Tyn Y Felin is a mere five minutes away from the A55 North Wales Coast Expressway and is a perfectly situated coastal retreat on the serene and beautiful Isle of Anglesey.