OraBlogger

TJ AbrahamsenHello there my friend. I am TJ, and my goal is to help you to become a successful Oracle developer (SQL and PL/SQL). Please don't hesitate to comment, email, or suggest topics. More...

Welcome to OraBlogger

How To Use Oracle Analytic Functions (part 4): AVG

E-mail Print PDF
(0 votes)

This is the fourth of the series about Oracle's Analytic Functions. Oracle Analytic Functions are functions that are similar to their respective aggregate function, but instead of returning a single record per group, there are multiple rows per group.

So far we have covered:
Introduction To Oracle's Analytic Functions
Oracle's COUNT Analytic Function
Oracle's SUM Analytic Function

In this part we will cover the AVG analytic function. The AVG analytic function returns the average value of a given field (or expression) returned by the query.

Add a comment
Last Updated on Thursday, 04 February 2010 17:42 Read more...

How To Use Oracle Analytic Functions (part 3): SUM

E-mail Print PDF
(0 votes)

This is the third part of the series about Oracle's Analytic Functions. Oracle Analytic Functions are functions that are similar to their respective aggregate function, but instead of returning a single record per group, there are multiple rows per group.

So far we have covered:
Introduction To Oracle's Analytic Functions
Oracle's COUNT Analytic Function

In this part we will cover the SUM analytic function. The SUM analytic function returns the summarized value of a given field (or expression) returned by the query.

Add a comment
Last Updated on Wednesday, 03 February 2010 16:02 Read more...

How To Use Oracle Analytic Functions (part 2): COUNT

E-mail Print PDF
(0 votes)

This is the second part of the series about Oracle's Analytic Functions. Oracle Analytic Functions are functions that are similar to their respective aggregate function, but instead of returning a single record per group, there are multiple rows per group.

So far we have covered:
Introduction To Oracle's Analytic Functions

In this part we will cover the COUNT analytic function. The COUNT analytic function returns the number of rows returned by the query.

Add a comment
Last Updated on Tuesday, 02 February 2010 17:18 Read more...

How To Use Oracle Analytic Functions (part 1)

E-mail Print PDF
(0 votes)

As a Data Warehouse Engineer in the Data Warehouse team for a large MLM (Multi Level Marketing) company it has become obvious to me that knowledge about Oracle's Analytic Functions is essential.

These analytic functions have become a part of the workday in the kind of reporting and analysis we do on a daily basis.

In this tutorial I will try to explain to you how to use them, through practical examples. You will probably have problems following this tutorial if you do not have knowledge about Oracle's aggregated functions...

Add a comment
Last Updated on Tuesday, 02 February 2010 01:03 Read more...

Page 1 of 3

  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  Next 
  •  End 
  • »

News

  • Library News

  • Tutorial News

REPLACE Function

The Oracle-PLSQL REPLACE returns a string where all the occurrences of a "match string" is replaced with a "replacement string.
Read more...
More:

ABS Function

ABS returns the absolute value of a number.
Add a comment Read more...

ASCII Table

Below is shown the standard 128 character ASCII Table .

Add a comment Read more...

How To Get Elapsed Time In PLSQL?

If you are familiar with with PLSQL you probably have wanted to find out, and show, how long time it takes to process something.

Like with me i.e., I am responsible for calculating the points ...

Read more...

How To Use Oracle Analytic Functions (part 4): AVG

This is the fourth of the series about Oracle's Analytic Functions . Oracle Analytic Functions are functions that are similar to their respective aggregate function, but instead of returni...

Read more...
More:
You are here: Home