Follow Us:

Oracle Forms and Reports Training in Chennai


Course Duration

40 Hours
Sign in with Facebook Sign in with Facebook

About 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.
  • Course Contents

    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
    Register Now

    You will Learn How To :


    Course Benefits :

    Register Now

    Please use the form below to make your career excellent.