Adapter Online Help > TDV Oracle Adapter > Oracle Function Support > Oracle Numeric Function Support
 
Oracle Numeric Function Support
TDV supports the numeric functions listed in the table below for Oracle.
Oracle Numeric Function
Notes
ABS
 
ACOS
 
ASIN
 
ATAN
 
ATAN2
 
CEIL
 
CEILING
 
COS
 
COT
 
DEGREES
Not available.
DENSE_RANK
 
EXP
 
FLOOR
 
LN
BIT, NCHAR, and NVARCHAR not supported.
LOG
 
MEDIAN
MEDIAN (DISTINCT) not supported.
MOD
 
PI
Not available.
POW
Not supported: mixing string, number, or NULL with BIT, NCHAR, or NVARCHAR.
POWER
 
RADIANS
Not available.
RANDOM
 
ROUND
 
SIGN
 
SIN
 
SQRT
 
TAN
 
TRUNC
 
VARIANCE