JDeveloper

Modules

Hide all

What is Oracle Discoverer (4 topics)

• Overview of Oracle Discoverer
• Oracle Discoverer Components
• Connecting to Oracle Discoverer
• Workbooks and Worksheets

Workbook Basics (5 topics)

• The Oracle Discoverer Workbook Window
• The Button Bars
• Displaying Data
• Selecting Worksheet Sections
• Viewing Pages

Workbook Formatting (3 topics)

• Re-ordering and Resizing Columns
• Formatting Headings and Data
• Worksheet Titles

Creating a Workbook (6 topics)

• Overview of Workbook Creation
• Adding a Table Layout Worksheet
• Adding a Crosstab Layout Worksheet
• Page-Detail Worksheets
• Duplicating Sheets
• Worksheet Management

Conditions (3 topics)

• Creating and Editing a Condition
• Creating and Using Parameters
• Advanced Conditions

Counts and Calculations (3 topics)

• Creating COUNTS on a worksheet
• Creating and Editing Calculations
• Introduction to Oracle functions

Graphing Your Data (5 topics)

• Overview of Graphs in Discoverer Worksheets
• The Graph Tool Bar
• Creating a Graph
• Modifying a Graph
• Drilling in a Graph

Workbook Manipulation (3 topics)

• Pivoting Data
• Drilling into Data
• Sorting Data

Data Analysis Tools (5 topics)

• Overview of the Data Analysis Tools
• Creating and Editing a Total
• Creating and Editing a Percentage
• Conditional Formatting with Exceptions
• Note - in practice this session may start on the first day

Reports (3 topics)

• Printed Reports
• Scheduled Reports
• Using the Scheduling Manager

Advanced Features (1 topic)

• Discoverer Options

Analyctic Functions (3 topics)

• Introduction - Oracle Analytic Functions and their Purpose
• Examples of Oracle Analytic Functions
• Creating Calculations using Oracle Analytic Functions

Discoverer Viewer (3 topics)

• Overview of Oracle Discoverer on the Web
• Creating Private Connections
• Using Oracle Discoverer Viewer