Training
Provided by 123-CBT Computer Based Training
Course Overview
This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.
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.
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 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
Unit 1: Additional Data Sources
Duration: 2 Hour(s)
- 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.
Unit 2: Charts, Reports and Timers: Integration in Forms
Duration: 2 Hour(s)
- 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.
Unit 3: Reusing Components, Objects and Code
Duration: 2 Hour(s)
- 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.
Unit 4: New Features in Form Builder
Duration: 1 - 2 Hour(s)
- 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.
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This program may be available on CD |  | Contact 123-CBT Computer Based Training for more information |
|
| Training Presented in: | English |
|
Related Keywords:
databases enterprise
oracle
information technology
ocad 2000 r2
developer 2000 build forms
cd web
1z0-122
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More Oracle Developer 2000 Release 2 Training from 123-CBT Computer Based Training
Click here for more information or to take this course
|
