Course Overview

Learn To:

• Implement the methods to use additional data sources on which to base data blocks.
• Work with Oracle8 objects in Form Builder.
• Understand the concepts behind reusability and the procedures to reuse components, objects, and code.
• Modify relations between two associated blocks by using programmatic control.
• Include charts, reports, and, timers in Forms modules by using wizards and built-ins.
• Understand the new features provided by Form Builder.

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 five 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); Oracle Developer: Project Builder and Menu Modules (62214); and, Oracle Developer: Controlling the User Interface Programmatically (62215).

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Identify the types of data sources used for data blocks.
• Base a data block on a FROM clause query.
• Create a data block based on a stored procedure that returns a REF cursor by using the Data Block Wizard.
• Create a data block based on the stored procedure that returns a table of records by using the Data Block Wizard.
• Identify the properties of a data block based on a stored procedure.
• Identify the performance implications of using stored procedures.
• Identify the guidelines to base a data block on a stored procedure.
• Identify the restrictions on performing database operations on data source objects.

• Identify the Oracle8 objects features.
• Identify how Oracle Developer treats Objects in the Object Navigator.
• Create a data block based on Oracle8 objects by using the Data Wizard.
• Create a data block on a table with a REF column by using the Data Wizard.
• Identify the benefits of using the REF LOVs.
• Create a REF LOV by using the Data Block Wizard.
• Update the REF values by using a REF LOV.

• Identify the benefits of reusing objects.
• Create a Property class with properties by using the Object Navigator.
• Create a Property Class by using the Property Palette.
• Inherit the properties from a property class into an object.
• Create an object group by using the Object Navigator.
• Copy an object in a Form Builder application by using the Object Navigator.
• Identify the features of a subclassed object.
• 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 by using the Tools menu.
• Create a SmartClass in Form Builder by using the Object Navigator.
• Sequence the steps to add a Help system to an application.
• Identify the methods to reuse PL/SQL in subprograms.
• Identify the features of PL/SQL libraries.
• Write the code to accept a reference to a bind module variable of local scope in a PL/SQLlibrary subprogram by using parameters.
• Populate a PL/SQL library module with objects from the Program Units node.
• Attach a PL/SQL library to a form module by using the Attach Library dialog box.
• Write a code to reference a library program unit within an attached library in a form module trigger.
• 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 a 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.
• Write a code to display a populated picklist by using Form Builder built-ins.

• Sequence the steps to create a relation.
• Match the Delete Record Behavior properties with their features.
• Identify the block coordination phases in a relation.
• Match the default relation-handling triggers with their properties.
• Match the default relation-handling triggers or procedures to the triggers or procedures that call them.
• Match the coordination properties with their functions.
• Sequence the steps to force a commit per master record.

• Match the chart types with their descriptions.
• Create a chart item in a Form module by using the Chart Wizard.
• Match the chart item properties with their descriptions.
• Create a report object based on a data block in a form module by using the Report Wizard.
• Identify the properties of Report Objects.
• 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.
• Write the code to manage timers by using built-ins.
• Identify the features of the When-Timer-Expired trigger.
• Sequence the steps involved in managing expired timers.

• Identify the functionality available in Form Builder to handle possible errors.
• Identify the order of preference for the location of PL/SQL code.
• Identify the Oracle8 Server features supported by client side PL/SQL8.
• Complete the code to dynamically perform database operations by using FORMS_DDL.
• Identify the errors that are caused by the failure of implicit DML statements.
• 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.

Click here for Secure Yahoo Order: Oracle Form Builder R6: Including Reusable Oracle Components

Get Train in Oracle
Oracle Training CBT

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