Oracle 9i New & Advanced Features For Developers > Oracle 9i New & Advanced Features For Developers > Section 10: Data Warehousing Features (Analytic Functions)

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle 9i New & Advanced Features For Developers

Search

Table of Contents

Oracle 9i New & Advanced Features For Developers

Table of Contents

Section 1: Course Introduction

Section 2: Using iSQL*Plus

Section 3: Advanced SQL Language Constructs

Section 4: Retrieving DDL With DBMS_METADATA()

Section 5: Advanced DBMS_METADATA() Processing

Section 6: Processing Dependent Objects With DBMS_METADATA()

Section 7: Redefining Tables With DBMS_REDEFINITION()

Section 8: Data Warehousing Features (External Tables)

Section 9: Data Warehousing Features (Table Functions)

Section 10: Data Warehousing Features (Analytic Functions)

Objectives

Understanding Analytic Functions

Using Ranking And Banding Functions

Using Windowing Functions

Using Lagging And Leading Functions

Using Reporting Aggregates

Workshop Section Data Warehousing Features (Analytic Functions)

Exercises

Solutions

Section 11: Complex SQL Operations

Section 12: SQL Statement Tuning

Section 13: Editing Private Outlines

Section 14: Collecting System Statistics

Section 15: Flashback Query

Section 16: Workspace Manager

Section 17: Invoking External Procedures

Oracle9i New & Advanced Features For Developers Page 234 Section 10 Data Warehousing Features (Analytic Functions) O bjectives Understanding Analytic Functions

Download Safari Books Online apps: Apple iOS | Android

This Book

Search

Contents

Oracle 9i New & Advanced Features For De... > Section 10: Data Warehousing Feature... - Pg. 234