Oracle Discoverer 4.1 for Power Users

Experienced Oracle Discoverer users are interested in knowing how the advanced features of the Oracle SQL language can be incorporated into Discoverer queries. During this 1-day course, users will learn how to enhance their queries through the use of correlated subqueries, functions, processing of hierarchies and other advanced SQL techniques. When these advanced techniques are combined with the ease-of-use features of Oracle Discoverer then users are fully empowered to extract crucial information from their databases and data warehouses.

Target audience

This course has been developed for all Oracle professionals including developers, database administrators, designers and analysts. Students should have attended the following courses or have equivalent knowledge and experience:

• Introduction To Oracle9i SQL & SQL*Plus
• Oracle Discoverer 4.1 Desktop User Edition
• Oracle Discoverer 4.1 Administration Edition

Course content

Advanced queries in Discoverer Fan Traps, Fan Trap Detection • Disabling the Fan Trap Detection Option • How do we get out of the trap? • Other Fan Trap Considerations • Multiple Join Paths, Creating a Query with Multiple Paths • Join Folders • Recursive Queries

Analytic functions The Analytic Function Template • Types of Analytic Functions • Ranking, Banding • Equi-Width Bands, Equi-Height Bands • Bands Using GREATEST, CASE, and NTILE • Windowing • Lagging/Leading • Statistical Functions • Slope, Intercept • Analytic Functions and Conditions

Hierarchical queries (connect by prior) One to Many (:N) Hierarchy • Many to Many (M:N) Hierarchy • M:N Hierarchy (Bill-of-Materials Table Definition) • Bill-of-Materials Explosion • Bill of Materials Implosion

Advanced hierarchical queries Expanding Displays for Hierarchical Queries • Setting Up the One to Many (1:M) Hierarchical Query for Multi-Level Display • Creating the Query in the Desktop User Edition • Setting Up the Many to Many (M:N) Hierarchical Query for Multi-Level Display

Writing and registering a PL/SQL function The Need for PL/SQL Functions • Writing the Function • Registering the Function • Using the Function

Alternate date sorts Changing a Date Format • Effect on the Date LOV • Defining an Alternate Date Sort

Discoverer debug trace Reasons for Creating a Debug Trace • Setting up the Debug Trace • The Debug Trace Diagnostic Levels • Generating the Debug Trace File • Using Metalink

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today