File Function Support
TDV supports the following types of functions for file data sources:
File Aggregate Function Support
TDV supports the aggregate functions listed in the table below for file data sources.
File Aggregate Function | Notes |
AVG | |
COUNT | |
MAX | |
MIN | |
SUM | |
File Character Function Support
TDV supports the character functions listed in the table below for file data sources.
File Character Function | Notes |
CONCAT | |
LENGTH | |
LOWER | |
REPLACE | |
RTRIM | |
SUBSTRING | |
TRIM | |
UPPER | |
File Conversion Function Support
TDV supports the conversion functions listed in the table below for file data sources.
File Conversion Function | Notes |
CAST | |
TO_CHAR | |
TO_DATE | |
TO_NUMBER | |
TO_TIMESTAMP | |
File Date Function Support
TDV supports the date functions listed in the table below for file data sources.
File Date Function | Notes |
CURDAY | |
CURTIME | |
CURTIMESTAMP | |
DAY | |
MONTH | |
YEAR | |
File Numeric Function Support
TDV supports the numeric functions listed in the table below for file data sources.
File Numeric Function | Notes |
ABS | |
ACOS | |
ASIN | |
ATAN | |
CEILING | |
COS | |
COT | |
DEGREES | |
EXP | |
FLOOR | |
LOG | |
PI | |
POWER | |
RADIANS | |
ROUND | |
SIN | |
SQRT | |
TAN | |