Function Reference
The Meta Database supports the SQL functions listed below.
For window functions, the syntax for window definitions must be used.
Aggregate Functions
Window Functions
Window Function Syntax and Usage
ANY_VALUE
FIRST_VALUE
LAST_VALUE
NTH_VALUE
LAG
LEAD
RANK
DENSE_RANK
ROW_NUMBER
Conditional Expressions
COALESCE
DECODE
IN & [NOT] IN
IS [NOT] NULL
NULLIF
NVL
NVL2
Mathematical Functions
ABS
CEIL
EXP
FLOOR
GREATEST
LEAST
LENGTH
LN
LOG
MOD
POWER
REMAINDER
ROUND
SIGN
SQRT
TRUNC
Mathematical Trigonometric Functions
ACOS
ASIN
ATAN
ATAN2
COS
COSH
SIN
SINH
TAN
TANH
System Functions
Text Functions
ASCII
CHR
CONCAT
INITCAP
INSTR
LOWER
LPAD
LTRIM
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REPLACE
RPAD
RTRIM
SUBSTR
TRANSLATE
TRIM
TO_CHAR
UPPER