IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
Oracle Reports

Duration: 3 days

Course Overview
This course gives the attendee an introduction to developing applications with Oracle Reports. Plenty of examples and hands-on experience will be given. On completion of this course the attendee will understand how to build simple and complex reports using Oracle Reports, and how to integrate Oracle Reports with other Oracle Developer tools.

Target Audience


The attendee should already have a good understanding of SQL & PL/SQL. Preferably they should have attended the Introduction to SQL & SQL*Plus and Introduction to PL/SQL Courses.

Course Content


Introduction
Concepts
Reports Server
User Interface
Invoking Oracle Reports
Creating a Simple Report
Executing the Report
Viewing Report Output
Using Live Previewer

Building the Data Model
Designing Queries
Group Filters
Dynamic Graphical Data
Calculated Columns
DDL and DML Support
Aggregation Facilities

Report Layout
The Graphical Painter
Co-ordinate Systems
Using Sizes and Angles
Drawing Boilerplate Text
Using Colour and Patterns
The Source Code Editor
Interactive Reports
OLE2 Support

Procedural Capabilities
PL/SQL Development Environment
PL/SQL Interpreter/Debugger
Libraries
Support for Stored Procedures
Built-in Packages
User Exits

Creating Reports
Tabular
Master-Detail
Mailing Label
Matrix - Simple, Break and Nested

Integration with Other Products
Invoking other Applications
Passing data to other Applications
Receiving data from other Applications
Integration with 3rd Party Products through User Exits

Wizards
Report, Chart and Web Wizards

Reports Sectioning
Defining Multiple Layouts
Header, Main and Trailer Sections

Enter your email address to register for our newsletter: