Price per person
€ 1.950,- (excluding VAT)
Duration of this course
3 days
Course dates
Dates not (yet) available / On request
Oracle Reports 11g: Fundamentals
This course is only available in Dutch. Would you prefer to take the course in English? Please contact us.
Oracle Developer is a suite of tools designed for building applications. Oracle Reports Builder, a component of Oracle Developer, is a powerful tool for developing and deploying report applications. Various types of reports can be created, such as simple lists, master-detail reports, matrix reports, nested matrix reports, mailing labels, and mail merges.
In this hands-on course, you will learn how to create different types of reports using Oracle Reports Builder. The course covers not only layout design but also the underlying data model, as a well-designed layout based on a poor data model can result in poorly performing reports.
The features of Oracle Reports Builder are taught in a workshop format, with 60% of the time dedicated to practical assignments and 40% to explanations and demonstrations.
You will Learn
- How choices in the data model affect the performance of a report.
- How to create default reports.
- How to modify a default-generated layout.
- How to use parameters in a report.
Topics
- Automatically and manually creating a report layout.
- Identifying and generating different layout styles.
- Creating nested and break matrix reports.
- Defining the data model and its possibilities.
- Defining summaries at various levels.
- Modifying layout objects in the live previewer and layout editor.
- Defining layout sections.
- Creating a parameter form.
- Controlling reports through parameters.
- Using PL/SQL, triggers, and the SRW package for complex reports.
- Using templates.
- Creating a dynamic layout with format triggers.
- Integration with other Oracle Developer tools.
Who should attend?
This course is intended for application developers who will be working with Oracle Reports Builder.
Prior knowledge
Basic knowledge from the courses Oracle 11g: Working with SQL and Oracle 11g: PL/SQL Programming is required.
Share this training
