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