Data Integration Connectors
- Data Integration Connectors
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
ANY_VALUE()
| COUNT()
| STDDEV_SAMP()
|
AVG()
| LISTAGG() | SUM()
|
BIT_AND() | MAX() | VAR_POP()
|
BIT_OR() | MEDIAN()
| VAR_SAMP()
|
BOOL_AND() | MIN()
| -
|
BOOL_OR() | STDDEV_POP()
| -
|
COALESCE()
| LEAST()
| NVL2()
|
DECODE()
| NULLIF()
| -
|
GREATEST()
| NVL()
| -
|
TEXT_TO_INT_ALT() | TO_CHAR() | TO_NUMBER() |
TEXT_TO_NUMERIC_ALT() | TO_DATE() | -
|
ADD_MONTHS() | DATE_PART_YEAR() | TIMEOFDAY() |
CONVERT_TIMEZONE() | DATE_TRUNC() | TIMESTAMP_CMP() |
DATE_CMP() | GETDATE() | TIMESTAMP_CMP_DATE() |
DATE_CMP_TIMESTAMP() | INTERVAL_CMP()
| TIMEZONE() |
DATEADD() | LAST_DAY() | TRUNC() |
DATEDIFF() | MONTHS_BETWEEN() | -
|
DATE_PART()
| NEXT_DAY() | -
|
CHECKSUM() | FNV_HASH() | SHA1() |
farmFingerprint64() | MD5() | SHA2() |
FUNC_SHA1() | SHA() | MURMUR3_32_HASH() |
ABS() | DEGREES() | POW() |
ACOS() | DEXP() | POWER() |
ASIN() | DLOG1() | RADIANS() |
ATAN() | DLOG10() | RANDOM() |
ATAN2() | EXP() | ROUND() |
CBRT() | FLOOR() | SIGN() |
CEIL() | LN() | SIN()
|
CEILING() | LOG() | SQRT() |
COS() | MOD() | TAN() |
COT() | PI() | TRUNC() |
ASCII() | LENGTH() | REVERSE() |
BPCHARCMP() | LOWER() | RIGHT() |
BTRIM() | LPAD() | RPAD() |
BTTEXT_PATTERN_CMP()
| LTRIM() | RTRIM() |
CHAR_LENGTH() | OCTETINDEX() | SOUNDEX() |
CHARACTER_LENGTH() | OCTET_LENGTH() | SPLIT_PART() |
CHARINDEX() | QUOTE_IDENT() | STRPOS() |
CHR() | QUOTE_LITERAL() | STRTOL() |
COLLATE() | REGEXP_COUNT() | SUBSTRING() |
CONCAT() | REGEXP_INSTR() | TEXTLEN() |
CRC32() | REGEXP_REPLACE() | TRANSLATE() |
DIFFERENCE() | REGEXP_SUBSTR() | TRIM() |
INITCAP() | REPEAT() | UPPER() |
LEFT() | REPLACE() | - |
LEN() | REPLICATE() | - |
AVG() | MAX() | STDDEV_SAMP() |
COUNT() | MEDIAN() | STDDEV() |
CUME_DIST() | MIN() | STDDEV_POP() |
DENSE_RANK() | NTH_VALUE() | SUM() |
FIRST_VALUE() | NTILE() | VAR_SAMP() |
LAG() | PERCENT_RANK() | VARIANCE() |
LAST_VALUE() | RANK() | VAR_POP() |
LEAD() | RATIO_TO_REPORT() | - |
LISTAGG() | ROW_NUMBER() | - |
