Search for Training

Oracle Forms and Reports

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Oracle Forms and Reports which gives you the opportunity to interact with a Oracle Forms and Reports instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 9 + 5? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234


Our Initiatives

ExpertsCertify - Skill Assessment And Tests
AreuCertified - Certification Training
Xpertised IT Solutions - Custom Application Development
Xpertised Learning - Redefine Skills

Subscribe to our weekly newsletter

Batch Details
  Request a Callback
Call us at: +91 7259222234