Oracle Forms and Reports Training Module

Oracle Forms and Reports

  • This Oracle forms is a software product for designing screens that communicate with oracle database.
  • It was originally developed to run server-side in character mode terminal sessions.
  • The primary focus of Forms to access the database is to design the data entry systems.
  • Duration

    40 Hours

    Oracle Forms and Reports
      INTRODUCTION AND OVERVIEW
    • Database, Forms and Reports
    • Introduction to Oracle Database
    • Physical Database Design
    • Database Management
    • Tables, Views, Indexes, Synonyms, Grants, Roles
    • Installing Oracle Forms and Reports
    • Architecture and toolset
    • Testing forms and reports
    • DESIGN PRINCIPLES
    • Using Form Builder Client/Server
    • Defining a consistent interface
    • Implementing user interface items
    • Selecting names, colour and layout
    • Building well-designed menus
    • Using the Menu Editor
    • Creating magic menu items and Alerts
    • Multi form applications
    • Screen Formation
    • Object Navigator, Blocks, Canvas, Windows
    • FORM BUILDER
    • Creating a Oracle Form
    • Oracle Form Designer
    • Elements of Form Designers, Menus and Libraries
    • Building single and master / Detail Forms
    • Using the Object Navigator
    • Defining data blocks using the Data Block Wizard
    • Using the Layout Editor
    • Working with interface items
    • Manipulating, arranging and formatting interface items
    • SQL STATEMENTS AND QUERIES
    • Data Types
    • Table Structure
    • Create Table
    • Insert Table
    • Select Table, where, like etc
    • Alter Tables, Columns
    • Update Table
    • Elements of Form Designers, Menus and Libraries
    • FORM BUILDER OPERATIONS WITH PL/SQL
    • PL/SQL programming
    • Developing well-structured code
    • Using local, global and system variables
    • PL/SQL Character set
    • Variables
    • IF clause, LOOPS, Null Clause, Exception handlers
    • Error handling, cursor
    • PL/SQL tables
    • Procedures, Functions and Triggers
    • Using Oracle-supplied routines
    • Creating user-named routines
    • Using a library to store reusable code
    • Stored Procedures
    • Creating Triggers
    • Coding and Compilation
    • Debugging techniques in Form Builder
    • Tracing Trigger Operation
    • Using the debugger facility
    • Break points and stack variables
    • Defining block and relation properties
    • Block navigation
    • WHERE and ORDER BY clauses
    • Implementing master-detail relationships
    • Creating a list of values and record group objects
    • setting record group properties
    • Designing queries to populate a list of values (LOV)
    • Designing windows and canvases
    • setting properties of content, stacked, toolbar and tab canvases
    • using the Layout Wizard
    • DESIGNING AND BUILDING REPORTS
    • The basic techniques
    • Setting default options
    • Using the Report Wizard
    • Creating the report data model
    • Designing report layouts
    • Specifying and developing layout objects
    • Editing and manipulating layout objects
    • Creating master-detail and tabular reports
    • Applying advanced techniques
    • Using triggers for validating parameters
    • Manipulating report format dynamically using triggers
    • CHARTS AND DISPLAYS WITH GRAPHICS BUILDER
    • Examining Graphics Builder components
    • Chart items and their properties
    • Data queries
    • Categories and values
    • Building graphical displays
    • Editing the layout
    • Defining chart items and specifying queries used for populating the chart
    • Testing and executing displays
    • Creating drill-down charts
    • Passing parameters between master and detail charts
    • Using layers to navigate between drill-down chart levels
    • BUILDING APPLICATIONS
    • Integrating Forms and Reports modules
    • Creating integrated applications
    • Passing parameters between Form Builder modules

    You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

    Best - SAP training center in London.