Oracle Reports

Duration: 
4 days
Codes: 
STA-OR

Overview

Not available. Please contact.

Audience

Who will the Course Benefit? Who will the Course Benefit?

The Oracle Reports course is designed for database administrators, software development and technical support personnel who need to create reports in a variety of styles and customize reports to meet their business requirements.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Creating paper and web reports
  • Defining report queries
  • Building reports in various different formats
  • Applying queries, groups, calculations and summaries to a report
  • Editing and manipulating boilerplate and layout objects
  • Editing and enhancing the Web source code
  • Using Cascading Stylesheets in Web Reports
  • Building master/detail and matrix reports
  • Building and using report templates
  • Using PL/SQL to base reports on ref cursor queries
  • Using PL/SQL trigger code for validating and formatting reports
  • Adding dynamic web links to reports
  • Using XML and text pluggable data sources in reports
  • Using Parameters in Reports
  • Adding graphics to a report
  • Distributing and bursting reports
  • Tuning reports
  • Maximizing report performance using Oracle AS Reports Services
  • Publishing reports on the Web
  • Adding dynamic data to an HTML page

Adding dynamic data to an HTML page Course Objectives Course Objectives

To provide the skills needed to design and create Web and paper reports using the Report Wizard.

Prerequisites

A working knowledge of SQL and PL/SQL is required. This can be obtained by attendance on the pre-requisite courses. Familiarity with basic XML and HTML would be an advantage.

Course Outline

The delegate will learn and acquire skills as follows:

  • Creating paper and web reports
  • Defining report queries
  • Building reports in various different formats
  • Applying queries, groups, calculations and summaries to a report
  • Editing and manipulating boilerplate and layout objects
  • Editing and enhancing the Web source code
  • Using Cascading Stylesheets in Web Reports
  • Building master/detail and matrix reports
  • Building and using report templates
  • Using PL/SQL to base reports on ref cursor queries
  • Using PL/SQL trigger code for validating and formatting reports
  • Adding dynamic web links to reports
  • Using XML and text pluggable data sources in reports
  • Using Parameters in Reports
  • Adding graphics to a report
  • Distributing and bursting reports
  • Tuning reports
  • Maximizing report performance using Oracle AS Reports Services
  • Publishing reports on the Web
  • Adding dynamic data to an HTML page

Adding dynamic data to an HTML page Course Objectives Course Objectives

To provide the skills needed to design and create Web and paper reports using the Report Wizard.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London4 3000 £3000 2019-11-25
London London4 3000 £3000 2019-11-25