Oracle Reports

      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.

Topics Covered

  • 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

Audience:

     Oracle application developers

Prerequisites:

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.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course

Length:

  • 4 Days

Price:

  • $1,980

Training Dates:

Sign Up