A
Calculation Examples

This appendix contains the following sections:

• Simple Calculation Examples

• Analytic Function Examples

• More about the Analytic Function Template

• Analytic Functions and Sequencing

Getting More Information

For more information about Analytic Functions, and Oracle functions in general, refer to the following Oracle publications:

• Oracle 8i SQL Reference Release 2 (8.1.6) - Part Number A76989-01

• Oracle 8i Data Warehousing Guide Release 2 (8.1.6) - Part Number A76994-01

About the examples in this chapter

The examples in the following sections use the Video Stores Tutorial.

Additional formatting

The examples in this chapter use the following additional formatting:

• Currency is displayed with no decimal places, and is prefixed with a Dollar sign ($).

• Integers are displayed with no decimal places.