Oracle Reports 9i

Students will use Oracle Reports in a client-server environment or web environment  Different styles of reports will be created with the use of wizards to assist in rapid development.  Reports will be customized using various editors and function enhanced through PL/SQL report triggers.  Reports will request and validate user input at runtime through the use of parameters.

Class Agenda:

• Oracle Reports overview
• Running Reports on the client
• Generating report output to HTML, PDF, etc.
• Creating tabular style reports
• Creating form style reports
• Creating from letter reports
• Creating mailing labels
• Creating break reports
• Creating master-detail reports
• Creating matrix reports
• Create or modify data model groups and columns
  • Summary, formula and placeholder columns
• Create or modify report layout objects
  • Boilerplate text, fields, frames, graphics
• Embedding charts
• Report parameters
• Report triggers
• Format triggers
• Using the built-in SRW package
• Report templates

Prerequisites:

• Oracle 9i SQL Fundamentals, Oracle PL/SQL Fundamentals or equivalent experience

Audience:

• Oracle application developers

Course Benefits:

• Students will be able to create and maintain a variety of report styles and customize the default report appearance.  They will also be able to enhance database function with summary, formula and placeholder columns, and utilize PL/SQL through group filters, report triggers, format triggers, program units, and PL/SQL libraries.

Materials Furnished:

• Student Manual

Recommended Follow-On Course:

• Oracle Forms 9i
• Oracle 9i Advanced SQL
• Oracle 9i Advanced PL/SQL

Course Length: Four Days

List Price: $1600