Cavg
|
Returns an ORDTNumSeries with each element containing the cumulative average up to and including the corresponding element in the input ORDTNumSeries . |
Cmax
|
Returns an ORDTNumSeries with each element containing the cumulative maximum up to and including the corresponding element in the input ORDTNumSeries . |
Cmin
|
Returns an ORDTNumSeries with each element containing the cumulative minimum up to and including the corresponding element in the input ORDTNumSeries . |
Cprod
|
Returns an ORDTNumSeries with each element containing the cumulative product of multiplication up to and including the corresponding element in the input ORDTNumSeries . |
Csum
|
Returns an ORDTNumSeries with each element containing the cumulative sum up to and including the corresponding element in the input ORDTNumSeries . |
DeriveExceptions
|
Derives calendar exceptions from a time series, a calendar and a table of dates, or two time series. |
Display
|
Displays various information using DBMS_OUTPUT routines. |
DisplayValTS
|
Displays the results returned by the ValidateTS function. |
ExtractCal
|
Returns a calendar that is the same as the calendar on which the time series is based. |
ExtractDate
|
Returns the date. |
ExtractTable
|
Returns the time series table (ORDTNumTab or ORDTVarchar2Tab ) associated with the time series. |
ExtractValue
|
Returns the value stored in a given element in a time series. |
Fill
|
Returns a time series in which values for missing dates are inserted. |
First
|
Returns the first element in a given time series. |
FirstN
|
Returns the first NumValues elements in the given time series. |
GetDatedElement
|
Returns the time series element for a given date. |
GetNthElement
|
Returns the Nth element (element whose position corresponds to target_index ) in the specified time series, or within the date range if one is specified. |
GetSeries
|
Returns a time series instance (ORDTNumSeries or ORDTVarchar2Series ). |
IsValidTS
|
Returns 1 if the time series is valid and 0 if the time series is invalid. |
Lag
|
Returns a time series that lags or (for negative numeric values) leads the input time series by the appropriate number of timestamps. |
Last
|
Returns the last element in a given time series. |
LastN
|
Returns the last NumValues elements in the time series. |
Lead
|
Returns a time series that leads or (for negative numeric values) lags the input time series by the appropriate number of timestamps. |
Mavg
|
Returns a moving average for the given time series, or for the date range if one is specified. |
Msum
|
Returns a moving sum for the time series, or for the date range if one is specified. |
TrimSeries
|
Returns an ORDT series of the same type with all data outside of the given date range removed. |
TSAdd
|
Given two input time series or a time series and a constant, and optionally starting and ending dates, returns a time series that reflects the addition of the first two parameters. |
TSAvg
|
Given an input ORDTNumSeries and optionally starting and ending dates, returns a number corresponding to the average of all non-null time series entries. |
TSCount
|
Given an input ORDTNumSeries and optionally starting and ending dates, returns a number corresponding to the count of all non-null time series entries. |
TSDivide
|
Given two input time series or a time series and a constant, and optionally starting and ending dates, returns a time series that reflects the division of the first parameter by the second parameter. |
TSMax
|
Given an input ORDTNumSeries and optionally starting and ending dates, returns a number corresponding to the highest (maximum) of all non-null time series entries. |
TSMaxN
|
Returns an ORDTNumTab with the specified number (NumValues ) of the top (highest ) values. |
TSMedian
|
Returns a number corresponding to the median of all non-null time series entries. |
TSMin
|
Returns a number corresponding to the lowest (minimum) of all non-null time series entries. |
TSMinN
|
Returns an ORDTNumTab with the specified number (NumValues ) of the bottom (lowest) values. |
TSMultiply
|
Given two input time series or a time series and a constant, and optionally starting and ending dates, returns a time series that reflects the multiplication of the first parameter by the second parameter. |
TSProd
|
Returns a number corresponding to the product (result of multiplication) of all non-null time series entries. |
TSStdDev
|
Returns a number corresponding to the standard deviation of all non-null time series entries. |
TSSubtract
|
Given two input time series or a time series and a constant, and optionally starting and ending dates, returns a time series that reflects the subtraction of the second parameter from the first parameter. |
TSSum
|
Returns a number corresponding to the sum of all non-null time series entries. |
TSVariance
|
Returns a number corresponding to the variance of all non-null time series entries. |
ValidateTS
|
Checks whether a time series is valid, and if the time series is not valid, outputs a diagnostic message and tables with timestamps that are causing the time series to be invalid. |