Oracle FR

Oracle Forms And Reports Training In Chennai

Vikapri course png
About Oracle Forms And Reports

Oracle Forms and Reports is a software product creates to design and develop Enterprise Applications.

Form Application offers UI access to Oracle DBA effectively.

This module includes Design principles, Form Builder, SQL Statements and Queries, Form Builder Operations with PL/SQL, Designing and Building Reports, Charts and Display with Graphics Builder.

We provide the best professional Oracle Forms And Reports Training In Chennai, in which you get advanced training sessions and hands-on projects by Experts.

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

Oracle Networking
  • Create listeners using Database Control
  • Create Oracle Net service aliases using Database Control
  • Controlling Oracle Net Listeners

Performing Database Backup
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Backup a control file to trace
  • Monitor flash recovery area

Performing Database Recovery
  • Database Recovery
  • Control file
  • Redo log file
  • System-critical data file
  • Non system-critical data file

Oracle Flashback Technologies
  • Flashback database
  • Flashback Table
  • Flashing Back Dropped Tables
  • Performing Flashback Query to view the contents of the database
  • Viewing transaction history

Moving Data In Oracle
  • Architecture of Data Pump
  • Using Data Pump export and import
  • Load data with SQL Loader
  • Use external tables to move data