| 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. |
|
| Covered Topics: |
- 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: |
|
| Recommended Follow-On Course: |
- Oracle Forms 9i
- Oracle 9i Advanced SQL
- Oracle 9i Advanced PL/SQL
|
|
|
|
|
|
