Banner Banner Banner Banner Banner Banner Banner Banner Banner

Oracle Forms and Reports

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