Oracle Discover 3.1 For Administrators

Request more details:

submit request
Description:
This course gives participants hands-on experience with administration tasks for Oracle`s Graphical User Interface (GUI) based ad hoc query and data access tool - Discoverer.

View other Oracle Courses available
Prerequisites:
Oracle Discoverer for End Users, familiarity with Windows 95/98 or Windows NT, Understanding of Relational Databases helpful.
Introduction:
Benefits of Discoverer
Components of Oracle Discoverer
Business areas
The told of the discoverer administrator
Setting up the Tutorial:
Starting Oracle Discoverer Administration edition
Grant access provileges to the users
Granting business area access
Customise items
Lists of values (LOV)
Alternative sorts
Calculated items
Designing complex folders
Creating and working with hierarchies
Create summary folders
Contents type
Building a New Business Area:
Building the business area
Managing a business area
Access Privilages and Secrity:
Using the privilages window
Database Security
Item Classes and List of Values:
Item classes
Joins:
Joins
Fan traps
Calculations:
Calculations
Conditions:
Conditions
Compound/complex conditions
Hierarchies:
Item Hierarchies
Date Hierarchies
Summaries:
Summary tables
Advanced Options:
Registering PL/SQL functions
Command line options