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