Scribd
Upload
165 views6 pages

Oracle Forms Reports Besant Technologies Course Syllabus

The document provides details about Oracle Forms and Reports training offered by Besant Technologies. The training will be held at their address in Chennai, India. It will cover both Forms and Reports over 35-40 hours through 20% theory and 80% hands-on training. The syllabus outlines topics that will be covered for both Forms and Reports development.

Uploaded by

Prasanna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
165 views6 pages

Oracle Forms Reports Besant Technologies Course Syllabus

The document provides details about Oracle Forms and Reports training offered by Besant Technologies. The training will be held at their address in Chennai, India. It will cover both Forms and Reports over 35-40 hours through 20% theory and 80% hands-on training. The syllabus outlines topics that will be covered for both Forms and Reports development.

Uploaded by

Prasanna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 6

For More Details Call +91-996 252 8293 / 94

Email ID – [email protected]

Oracle Forms & Reports Course Details


By Besant Technologies

Course Name Oracle Forms & Reports

Category Oracle Fusion Middleware

Venue Besant Technologies

No.24, Nagendra Nagar, Velachery Main Road,


Address Velachery, Chennai – 600 042
Landmark – Opposite to Phoenix Market City

Official URL Oracle Forms & Reports Training

Demo Classes At Your Convenience

Training Methodology 20% Theory & 80% Practical

Course Duration 35-40 Hours

Class Availability Weekdays & Weekends

Call - +91-996 252 8293 / 94


For Demo Class
Email ID – [email protected]

Why Besant Technologies?


 Training by highly experienced and certified professionals
 No slideshow (PPT) training, fully Hand-on training
 Interactive session with interview QA’s
 Real-time projects scenarios & Certification Help
 Most competitive & affordable course fees
 Placement support for all courses
 List of established & satisfied clients & students (Visit our website for reviews).
For More Details Call +91-996 252 8293 / 94
Email ID – [email protected]

Forms & Reports Training Syllabus


Introducing Oracle Forms Developer and Forms Services
 Grid Computing
 Oracle 10g Products
 Oracle Application Server 10g Architecture
 Benefits and Components of Oracle Developer Suite 10g
 Running a Forms Developer Application
 Working in the Forms Developer Environment
Creating Forms Modules
 Creating a Basic Forms Module
 Creating a Master-Detail Forms Module
 Modifying the Data Block
 Modifying the Layout
Working with Data Blocks and Frames
 Using the Property Palette
 Managing Object Properties
 Creating and Using Visual Attributes
 Controlling the Behaviour and Appearance of Data Blocks
 Controlling Frame Properties
 Creating Control Blocks
 Deleting Data Blocks
Working with Input Items
 Creating Text Items
 Controlling the Behaviour and Appearance of Text Items
 Creating LOVs
 Defining Editors
 Creating Check Boxes
 Creating List Items
 Creating Radio Groups
Working with Non Input Items
 Creating a Display Item
 Creating an Image Item
 Creating a Push Button
 Creating a Calculated Item
 Creating a Hierarchical Tree Item
 Creating a Bean Area Item
Working with Windows and Canvases
 Overview of Windows and Canvases
For More Details Call +91-996 252 8293 / 94
Email ID – [email protected]

 Displaying a Forms Module in Multiple Windows


 Creating a New Window
 Displaying a Forms Module on Multiple Layouts
 Creating a New Content Canvas
 Creating a New Stacked Canvas
 Creating a New Toolbar Canvas
 Creating a New Tab Canvas
Producing Triggers
 Grouping Triggers into Categories
 Defining Trigger Components: Type, Code, and Scope
 Specifying Execution Hierarchy
 Using the PL/SQL Editor
 Writing Trigger Code
 Using Variables and Built-ins
 Using the When-Button-Pressed and When-Window-Closed Triggers
Debugging Triggers
 The Debugging Process
 The Debug Console
 Setting Breakpoints
 Debugging Tips
 Running a Form in Debug Mode
 Stepping through Code
Adding Functionality to Items
 Coding Item Interaction Triggers
 Defining Functionality for Check Boxes
 Changing List Items at Run Time
 Displaying LOVs from Buttons
 Populating Image Items
 Populating and Displaying Hierarchical Trees
 Interacting with JavaBeans
Run-Time Messages and Alerts
 Built-ins and Handling Errors
 Controlling System Messages
 The FORM_TRIGGER_FAILURE Exception
 Using Triggers to Intercept System Messages
 Creating and Controlling Alerts
 Handling Server Errors
For More Details Call +91-996 252 8293 / 94
Email ID – [email protected]

Query Triggers
 SELECT Statements Issued During Query Processing
 WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
 Writing Query Triggers
 Query Array Processing
 Coding Triggers for Enter-Query Mode
 Overriding Default Query Processing
 Obtaining Query Information at Run Time
Validation
 Validation Process
 Controlling Validation Using Properties
 Controlling Validation Using Triggers
 Performing Client-Side Validation with PJCs
 Tracking Validation Status
 Using Built-ins to Control When Validation Occurs
Navigation
 Navigation Overview
 Understanding Internal Navigation
 Using Object Properties to Control Navigation
 Writing Navigation Triggers: When-New–Instance, Pre- and Post- Triggers
 The Navigation Trap
 Using Navigation Built-ins in Triggers
Transaction Processing
 The Commit Sequence of Events
 Characteristics and Common Uses of Commit Triggers
 Testing the Results of Trigger DML
 DML Statements Issued During Commit Processing
 Overriding Default Transaction Processing
 Running Against Data Sources Other Than Oracle
 Getting and Setting the Commit Status
 Implementing Array DML
Writing Flexible Code
 What Is Flexible Code?
 Using System Variables for Flexible Coding
 Using Built-in Subprograms for Flexible Coding
 Referencing Objects by Internal ID
 Referencing Items Indirectly
For More Details Call +91-996 252 8293 / 94
Email ID – [email protected]

Sharing Objects and Code


 Working with Object Libraries
 Working with Smart Classes
 Reusing PL/SQL
 Working with PL/SQL Libraries
Using WebUtil to Interact with the Client
 Benefits of WebUtil
 Integrating WebUtil into a Form
 Interacting with the Client
Introducing Multiple Form Applications
 Multiple Form Applications Overview
 Starting Another Forms Module
 Defining Multiple Form Functionality
 Sharing Data Among Modules

Oracle Reports Training Syllabus


Basic Concepts
 Oracle Reports Builder
 Reports
 Report Styles
 Wizards
 The Object Navigator
 The Report Editor
 Data Model Objects
 Layout Objects
 Parameter Form Objects
 The Property Instructor
 Runtime Views
 Oracle Reports Components
Advanced Concepts
 Reports
 Web Reports
 Data Model Objects
 Layout Objects
 Parameter Form Objects
 PL/SQL
 Templates
 Output Formats and Capabilities
For More Details Call +91-996 252 8293 / 94
Email ID – [email protected]

 Data Sources
 Debugging Tools
Visual Index
 Building Basic Reports
 Building Group Reports
 Building Reports w/ Special Formatting
 Building Matrix Reports
 Building Reports for Business Cases
 Building Reports w/ PL/SQL and Java
 Building Reports w/ Pluggable Data Sources
How to
 Access Oracle Reports Documentation
 Set Properties and Preferences
 Perform Common Tasks
 Work with the Object Navigator
 Work with Reports
 Work with Web Reports
 Run and Dispatch a Report
 Work with the Data Model
 Work with the Report Layout
 Work with Report Sections
 Work with Parameters and the Parameter Form
 Define a Template
 Use PL/SQL in a Report or Template
 Debug a Report
 Integrate with Other Products
 Administer Oracle Reports Builder

You might also like