Oracle 9i DBA II Fast Track

Course Description

This course discusses the following topics:

· The use of Oracle Reports in a client-server environment or a web environment.

· The default reports that can be built with Oracle Reports.

· The use of wizards to assist in the rapid development of reports.

· Format and output of reports for the web using the Web Wizard.

Students would take this course for these reasons:

· Learn how to create a variety of reports.

· Use the Web Wizard to add web functionality to reports.

· Add PLSQL code and parameters to reports to automate them.

· Run a report on the web or in a client-server environment.

By the end of this course, students will have covered how to perform the following tasks...

· Create several types of reports using Oracle Reports, including tabular, master-detail, mailing label, matrix, and form letter reports.

· Tailor default reports by adding text and/or graphics.

· Request parameter information from users at runtime.

· Enhance functionality of default reports with PL/SQL triggers.

· Customize reports for the web.

Who Needs to Attend:

Application Developers, Database Administrators, Business or Data Analysts

Prerequisites:

Knowledge of SQL and PL/SQL or ORA300 – Introduction to Oracle using SQL and PL/SQL class.

Experience with GUI tools is a must. Experience with Oracle Forms would be helpful.

Course Content:

1 INTRODUCTION TO ORACLE REPORTS

¨ ORACLE REPORTS ON THE CLIENT, ON THE WEB

¨ REPORT BUILDER, REPORT SYNCHRONIZATION, REPORTS HELP

¨ LAB EXERCISE

2 RUN A REPORT ON THE CLIENT

¨ RUN A REPORT ON THE CLIENT – PAPER DESIGN, WEB LAYOUT, and FROM THE COMMAND LINE

¨ PASS A PARAMETER TO A REPORT, GENERATE REPORT OUTPUT

¨ LAB EXERCISE

3 CREATE TABULAR REPORTS

¨ CREATE A TABULAR REPORT, THE REPORT WIZARD, REPORT CHOICES, and STYLE, DATA SOURCE TYPE, and DEFINITION

¨ QUERY BUILDER, DATA SOURCE DEFINITION

¨ DISPLAYED FIELDS IN THE REPORT, ADD SUMMARIES, MODIFY LABELS

¨ REPORT TEMPLATES, REPORT VIEWER, SAVE REPORT

¨ LAB EXERCISE

4 CREATE MASTER-DETAIL REPORTS

¨ CREATE A MASTER GROUP, and MASTER QUERY, CHOOSE MASTER GROUP FIELDS, CREATE A DETAIL GROUP IN THE WIZARD

¨ DATA MODEL FOR A SINGLE REPORT and FOR A MASTER DETAIL REPORT

¨ LAYOUT FOR A GROUP LEFT REPORT

¨ CREATE A DETAIL GROUP MANUALLY, and A GROUP ABOVE REPORT, DATA MODEL FOR A GROUP ABOVE REPORT

¨ GROUP FIELDS, REPEATING FRAMES

¨ ADD A PAGE NUMBER TO THE HEADER/FOOTER, A DATE TO THE REPORT, and CUSTOM DATE AND TIME

¨ LAB EXERCISE

5 CREATE FORM LETTER REPORTS

¨ CREATE A FORM LETTER, FORM LETTER QUERY, FORM LETTER TEXT, and ADD BOILERPLATE IN THE LAYOUT

¨ EXPLORE THE MARGIN SECTION ADD BOILERPLATE TO THE MARGIN, and IMPORT AN IMAGE

¨ LAB EXERCISE

6 CREATE MAILING LABEL REPORTS

¨ CREATE MAILING LABELS, and MAILING LABEL QUERY, and ADD BOILERPLATE TO MAILING LABELS

¨ REPEATING FRAMES IN MULTIPLE DIRECTIONS and FRAME PROPERTY INSPECTOR

¨ LAB EXERCISE

7 CREATE FORM REPORTS

¨ CREATE A FORM-LIKE REPORT, CREATE FORM REPORT QUERY, and FORM REPORT LABELS

¨ CREATE A FIELD IN THE PAPER LAYOUT, FIELD PROPERTY INSPECTOR, and TOOLBARS IN THE LAYOUT

¨ CHANGE COLORS IN THE LAYOUT, CONVERT A REPORT, CREATE REPORT DOCUMENTATION

¨ LAB EXERCISE

8 CREATE DATA MODEL GROUPS

¨ OBJECTS IN THE DATA MODEL, CREATE A QUERY IN THE DATA MODEL

¨ QUERY PROPERTY INSPECTOR, and GROUP PROPERTY INSPECTOR

¨ ADD A GROUP FILTER, CREATE ADDITIONAL QUERIES, and LINK QUERIES

¨ CREATE A PL/SQL QUERY, and A PL/SQL PACKAGE AND QUERY FUNCTION

¨ REF CURSOR PROPERTY INSPECTOR

¨ LAB EXERCISE

9 CREATE DATA MODEL COLUMNS

¨ CREATE A SUMMARY COLUMN, SUMMARY COLUMN PROPERTY INSPECTOR, A GRAND TOTAL, and A FORMULA COLUMN, FORMULA COLUMN PROPERTY INSPECTOR

¨ CREATE A PLACEHOLDER COLUMN, PLACEHOLDER COLUMN PROPERTY INSPECTOR, and PLACEHOLDER CODE

¨ THE COLUMN PROPERTY INSPECTOR

¨ DISPLAY DATA FROM THE OPERATING SYSTEM

¨ LAB EXERCISE

10 CREATE MATRIX REPORTS

¨ CREATE A MATRIX REPORT, ADD SUMMARIES TO A MATRIX REPORT, MATRIX REPORT LABELS, OUTPUT, DATA MODEL, and MATRIX LAYOUT

¨ CREATE A MATRIX IN THE DATA MODEL, and A CROSS PRODUCT IN THE DATA MODEL

¨ LAB EXERCISE

11 ENHANCE MATRIX REPORTS

¨ CREATE A MATRIX GROUP REPORT, and GROUP QUERY

¨ CREATE MATRIX GROUP, ROWS, COLUMNS, CELL FIELDS, SUMMARIES, and LABELS

¨ THE MATRIX GROUP DATA MODEL, LAYOUT, and OUTPUT

¨ CREATE A NESTED MATRIX REPORT, ROWS, OUTPUT, and LAYOUT

¨ ADD MATRIX SUMMARIES IN THE DATA MODEL

¨ DISPLAY ZEROS IN EMPTY CELLS, and IN EMPTY MATRIX CELLS

¨ LAB EXERCISE

12 PASS PARAMETERS TO A REPORT

¨ SYSTEM PARAMETERS, CREATE A BIND PARAMETER, PARAMETER PROPERTY INSPECTOR, VALIDATION TRIGGERS

¨ CREATE A LEXICAL PARAMETER, LEXICAL PARAMETER PROPERTY INSPECTOR

¨ STATIC LIST OF VALUES, BIND VS. LEXICAL

¨ GENERATE PARAMETER FORM, EDITOR, SIZE, and AT RUNTIME

¨ LAB EXERCISE

13 CREATE OR MODIFY LAYOUT OBJECTS

¨ CREATE A HEADER and A TRAILER PAGE, FORMATTING DATA, CONDITIONAL FORMATTING, and OUTPUT

¨ CONFINE MODE OFF and ON, FLEX MODE OFF and ON

¨ SELECT PARENTFRAME, PRINT OBJECTS, and OBJECT ELASTICITY

¨ PAGE BREAKS, PAGE BREAK SYMBOL, MULTI-PANEL REPORTS, COLUMN MODE

¨ CREATE A REPORT BLOCK, CREATE EXPLICIT ANCHORS, EXPLICIT ANCHOR PROPERTY INSPECTOR

¨ REPORT DISTRIBUTION

¨ LAB EXERCISE

14 EMBED A GRAPH IN A REPORT

¨ START THE GRAPH WIZARD, SELECT THE GRAPH TYPE, POSITION THE GRAPH

¨ CHOOSE THE X AXIS and THE Y AXIS

¨ GRAPH LAYOUT, TITLES , LEGEND, OPTIONS, OUTPUT, and PROPERTY INSPECTOR

¨ ADD A GRAPH HYPERLINK

¨ LAB EXERCISE

15 CREATE REPORTS FOR THE WEB

¨ JSP, WEB SOURCE, JSP TAGS

¨ CREATE A BOOKMARK, GENERATE HTML and PDF OUTPUT

¨ PDF REPORT, ADD HTML HEADER OR FOOTER, HYPERLINKS, and REPORT ESCAPES

¨ LAB EXERCISE

16 RUN A REPORT ON THE WEB

¨ ENVIRONMENT VARIABLES

¨ STATIC and DYNAMIC REPORTING, Running a Report

¨ THREE-TIER ARCHITECTURE: The Client, The Application Server , The Database Server

¨ HOW TO DEPLOY A REPORT, and TEST THE REPORT ON THE CLIENT and THE REPORT IN A WEB BROWSER

17 CREATE REPORT TRIGGERS

¨ FIVE REPORT TRIGGERS, PL/SQL BLOCK STRUCTURE

¨ CREATE A PROCEDURE OR FUNCTION, CREATE A REPORT TRIGGER, VIEW A REPORT TRIGGER

¨ CREATE A PL/SQL LIBRARY, STORE CODE IN A PL/SQL LIBRARY, ATTACH A PL/SQL LIBRARY

¨ STORED PROCEDURES VS. LIBRARIES

¨ LAB EXERCISE

18 CREATE OTHER REPORT TRIGGERS

¨ GROUP FILTER TRIGGERS, VALIDATION TRIGGERS,

¨ FORMAT TRIGGERS ON FIELDS, and ON FRAMES

¨ LAB EXERCISE

19 THE SRW PACKAGE

¨ THE SRW PACKAGE

¨ SEND A MESSAGE, RUN A REPORT IN THE BACKGROUND, SET FIELD VALUES

¨ ANOTHER OPTION FOR PAGE NUMBERS, PERFORM SQL STATEMENTS , SET FORMATTING

¨ LAB EXERCISE

20 USE XML IN ORACLE REPORTS

¨ XML

¨ GENERATE XML OUTPUT and RUN AN XML REPORT

¨ REPORT DEFINITION TAGS

¨ PARTIAL XML REPORT and COMPLETE XML REPORT, APPLY AN XML FORMAT

21 USE THE REPORT QUEUE MANAGER

¨ REPORT SERVICES, and REPORT QUEUE MANAGER, SCHEDULE A REPORT JOB

Unique Training Solutions for Unique Clients - Expanding skills today to meet the challenges of tomorrow