Function | Availability |
|---|---|
%OPR_CONCAT% | Available in all mappings |
%OPR_CONCATDELIM% | Available in all mappings |
%OPR_IIF% | Available in all mappings |
%OPR_SUM% | Available in all mappings |
ABORT | Available outside of advanced mode |
ABS | Available in all mappings |
ADD_TO_DATE | Available in all mappings |
AES_DECRYPT | Available in all mappings |
AES_ENCRYPT | Available in all mappings |
AES_GCM_DECRYPT | Available in all mappings |
AES_GCM_ENCRYPT | Available in all mappings |
ASCII | Available in all mappings |
AVG | Available in all mappings |
CEIL | Available in all mappings |
CHOOSE | Available in all mappings |
CHR | Available in all mappings |
CHRCODE | Available in all mappings |
COMPRESS | Available in all mappings |
CONCAT | Available in all mappings |
CONVERT_BASE | Available in all mappings |
COS | Available in all mappings |
COSH | Available in all mappings |
COUNT | Available in all mappings |
CRC32 | Available in all mappings |
CUME | Available outside of advanced mode |
DATE_COMPARE | Available in all mappings |
DATE_DIFF | Available in all mappings |
DEC_BASE64 | Available in all mappings |
DECODE | Available in all mappings |
DECOMPRESS | Available in all mappings |
ENC_BASE64 | Available in all mappings |
ERROR | Available outside of advanced mode |
EXP | Available in all mappings |
FIRST | Available outside of advanced mode Available in advanced mode only as a window function |
FLOOR | Available in all mappings |
FV | Available in all mappings |
GET_DATE_PART | Available in all mappings |
GREATEST | Available in all mappings |
IIF | Available in all mappings |
IN | Available in all mappings |
INDEXOF | Available in all mappings |
INITCAP | Available in all mappings |
INSTR | Available in all mappings |
IS_DATE | Available in all mappings |
IS_NUMBER | Available in all mappings |
IS_SPACES | Available in all mappings |
ISNULL | Available in all mappings |
LAG | Available in advanced mode |
LAST | Available outside of advanced mode Available in advanced mode only as a window function |
LAST_DAY | Available in all mappings |
LEAD | Available in advanced mode |
LEAST | Available in all mappings |
LENGTH | Available in all mappings |
LN | Available in all mappings |
LOG | Available in all mappings |
LOWER | Available in all mappings |
LPAD | Available in all mappings |
LTRIM | Available in all mappings |
MAKE_DATE_TIME | Available in all mappings |
MAX (Dates) | Available in all mappings |
MAX (Numbers) | Available in all mappings |
MAX (String) | Available in all mappings |
MD5 | Available in all mappings |
MEDIAN | Available in all mappings |
METAPHONE | Available in all mappings |
MIN (Dates) | Available in all mappings |
MIN (Numbers) | Available in all mappings |
MIN (String) | Available in all mappings |
MOD | Available in all mappings |
MOVINGAVG | Available outside of advanced mode |
MOVINGSUM | Available outside of advanced mode |
NPER | Available in all mappings |
PERCENTILE | Available in all mappings |
PMT | Available in all mappings |
POWER | Available in all mappings |
PV | Available in all mappings |
RAND | Available in all mappings |
RATE | Available in all mappings |
REG_EXTRACT | Available in all mappings |
REG_MATCH | Available in all mappings |
REG_REPLACE | Available in all mappings |
REPLACECHR | Available in all mappings |
REPLACESTR | Available in all mappings |
REVERSE | Available in all mappings |
ROUND | Available in all mappings |
RPAD | Available in all mappings |
RTRIM | Available in all mappings |
SET_DATE_PART | Available in all mappings |
SETCOUNTVARIABLE | Available in all mappings |
SETMAXVARIABLE | Available in all mappings |
SETMINVARIABLE | Available in all mappings |
SETVARIABLE | Available outside of advanced mode |
SHA256 | Available outside of advanced mode |
SIGN | Available in all mappings |
SIN | Available in all mappings |
SINH | Available in all mappings |
SOUNDEX | Available in all mappings |
SQRT | Available in all mappings |
STDDEV | Available in all mappings |
SUBSTR | Available in all mappings |
SUM | Available in all mappings |
SYSTIMESTAMP | Available in all mappings |
TAN | Available in all mappings |
TANH | Available in all mappings |
TO_BIGINT | Available in all mappings |
TO_CHAR | Available in all mappings |
TO_DATE | Available in all mappings |
TO_DECIMAL | Available in all mappings |
TO_FLOAT | Available in all mappings |
TO_INTEGER | Available in all mappings |
TRUNC | Available in all mappings |
UPPER | Available in all mappings |
VARIANCE | Available in all mappings |