Oracle Reports
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
4 Days
By the end of this course, delegates will understand the main concepts of Oracle Reports Developer. The course is designed to give delegates practical experience in designing and creating web and paper reports using the Report Wizard. They will also be able to add dynamic report data to static HTML pages and publish reports on the web. Suitable for: This course is aimed at database administrators, software developers and technical support personnel who need to create reports in a variety of styles and customise reports to meet their business requirements.
Facilities
Location
Start date
Start date
About this course
A working knowledge of SQL*Plus and PL/SQL is required. T his can be obtained by attendance on the pre-requisite courses. Familiarity with basic XML and HTML would be an advantage.
Reviews
Course programme
This course is aimed at database administrators, software developers and technical support personnel who need to create reports in a variety of styles and customise reports to meet their business requirements.
Objectives:
By the end of this course, delegates will understand the main concepts of Oracle Reports Developer. The course is designed to give delegates practical experience in designing and creating web and paper reports using the Report Wizard. They will also be able to add dynamic report data to static HTML pages and publish reports on the web.
Topics Covered:
- 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
- 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
- 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
Oracle Reports