Oracle Discover 3.1 For Administrators
Course 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
View other Oracle Courses available
2 Days
Contact us for pricing
Prerequisites
Oracle Discoverer for End Users, familiarity with Windows 95/98 or Windows NT, Understanding of Relational Databases helpful.Introduction
Benefits of DiscovererComponents of Oracle Discoverer
Business areas
The told of the discoverer administrator
Setting up the Tutorial
Starting Oracle Discoverer Administration editionGrant 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 areaManaging a business area
Access Privilages and Secrity
Using the privilages windowDatabase Security
Item Classes and List of Values
Item classesJoins
JoinsFan traps
Calculations
CalculationsConditions
ConditionsCompound/complex conditions
Hierarchies
Item HierarchiesDate Hierarchies
Summaries
Summary tablesAdvanced Options
Registering PL/SQL functionsCommand line options