List of Tables

1-1 Oracle8i Time Series Demos

1-2 Quick-Start Demo Files

1-3 Usage Demo Files

2-1 Frequency Codes

2-2 Frequencies and Their Requirements

2-3 Precisions Using 01-Jan-1998 00:00:00 Anchor Date

2-4 End-User Calendar Functions

2-5 Product-Developer Calendar Functions

2-6 Extraction Functions

2-7 Retrieval and Trim Functions

2-8 Shift Functions

2-9 SQL Formatting Functions

2-10 Aggregate Functions

2-11 Arithmetic Functions

2-12 Cumulative Sequence Functions

2-13 Moving Average and Sum Functions

2-14 Conversion Functions

2-15 Scaling Compatibility Matrix

2-16 Scaleup Functions for Collections

2-17 Scaledown Functions for Collections

2-18 IgnoreNulls and DiscardError Syntax Options

2-19 Administrative Tools Procedures

4-1 SetPrecision and Timestamp of 19-Sep-1997 09:09:09

4-2 Errors Repaired by ValidateCal

5-1 Lagging a Time Series by Two Days

5-2 Leading a Time Series by Two Days

6-1 annualfactor Default Values for ScaleupSumAnnual

B-1 xxx_TIMESERIES_GROUPS Columns

B-2 xxx_TIMESERIES_COLS Columns

B-3 xxx_TIMESERIES_OBJS Columns

B-4 ts_obj_type Column Values

---