SQL/MX Functions and Expressions Compatible with Oracle
The following SQL/MX functions and expressions are compatible with Oracle:
Aggregate Functions
- AVG
- COUNT
- MAX
- MIN
- STDDEV
- SUM
- VARIANCE
Character String Functions
-
ASCII
-
COALESCE
-
CONCAT
-
CONVERT
-
CURRENT_USER
-
DECODE
-
LOWER
-
LTRIM
-
LNNVL
-
NULLIF
-
NVL
-
NVL2
-
RTRIM
-
TO_CHAR
-
TRANSLATE
-
TRIM
-
USER
Datetime Functions
- CURRENT_TIMESTAMP
- EXTRACT
- LAST_DAY
- MONTHS_BETWEEN
- TO_DATE
Mathematical Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- AVG
- COS
- COSH
- EXP
- FLOOR
- MOD
- POWER
- ROUND
- SIGN
- SQRT
- SIN
- SINH
- TAN
- TANH
Expressions
- CAST