Courses » Oracle Courses » Oracle Forms and Reports Online Training

 

Oracle Forms and Reports Online Training

 

Oracle Forms and Reports Course Content

Introduction to PL/SQL

Objectives

• Describe the building blocks of PL/SQL and its environment
• Explain the benefits of the basic components of PL/SQL structures
• Explain the benefits of packages over stand-alone procedures and functions
• Create various types of triggers
• Create and use procedures

Topics

• PL/SQL
• PL/SQL Structures
• Packages
• Triggers
• Stored Procedures
• Overview of Developer/2000

Objectives

• Navigate the menus and toolbars of the development environment
• Describe the features available for editing and debugging an application
• Explain the features that provide object-orientation, product integration, and OLE2 support

Topics

• Introducing Oracle Applications
• The Windows Interface
• The Object Navigators
• Setting Object Properties
• Introducing the Layout Editors
• Working with Objects in the Layout Editor
• Introducing the PL/SQL Editors
• Getting Help
• Object Orientation and OLE2
• Forms 4.5 and Reports 2.5

Objectives

• Develop a Forms application, a menu, and a library
• Use the PL/SQL Editor in Oracle Forms
• Develop tabular and master/detail reports
• Use the Data Model Editor, Parameter Form Editor, and Program Unit Editor in Oracle Reports

Topics

• Overview of Oracle Forms
• Introducing Forms Designer
• The Layout Editor
• The PL/SQL and Menu Editors
• Creating Forms Objects and Libraries
• Overview of Oracle Reports
• Introducing Reports Designer
• The Reports Designer Editors
• Displaying Report-Style Formats
• Graphics 2.5 and Procedure Builder 1.5

Objectives

• Develop a pie chart and a column chart
• Use the Chart Template Editor in Oracle Graphics
• Develop functions, procedures, packages, and database triggers
• Use the Database Trigger Editor in Oracle Procedure Builder

Topics

• Overview of Oracle Graphics
• Introducing Graphics Designer
• The Layout Editor
• The Chart Template and Program Unit Editors
• Displaying Chart Types
• Overview of Procedure Builder
• Introducing Procedure Builder
• The Procedure Builder Editors
• Debugging PL/SQL Program Units
• Developer/2000 Applications

Objectives

• Create Oracle Forms templates containing visual attributes, property classes, a toolbar, and triggers
• Use OLE2 in your application
• Use Visual Basic Custom Controls to enhance your application
• Create Oracle Reports templates containing standard headers, trailers, and margin items
• Create break, drill-down, and integrated application reports using templates and OLE2
• Add buttons and PL/SQL to drill-down into a detail report
• Create a report trigger for auditing

Topics

• Developing Oracle Forms Applications
• Developing Oracle Reports Applications
• Developer/2000 Integration
• Objectives
• Create a parameter-driven display
• Pass parameters from Oracle Forms to Oracle Graphics
• Create a format trigger to conditionally modify a chart
• Import an image file
• Create multiple environments for development, testing, demonstration, training, and production
• Recognize GUI styles and standards
• Optimize memory, disk space, and performance
• Insert OLE2 objects into an Oracle database Topics
• Developing Oracle Graphics Applications
• Integration and Deployment in the Windows Environment