Course Search:
Request more details:


Print Page

Oracle Discover 3.1 For Administrators

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
  • Cost: Price on application
  • Duration: 2 Days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.