• SQL Functions Mapping to Other Databases
• Numeric Functions
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • COS
  • EXP
  • LOGN
  • LOG10
  • MOD
  • POW
  • ROOT
  • ROUND
  • SIN
  • SQRT
  • TAN
  • TRUNC
• String Functions
  • CHAR_LENGTH
  • INITCAP
  • LENGTH
  • LOWER
  • LPAD
  • OCTET_LENGTH
  • REPLACE
  • RPAD
  • SUBSTR
  • TRIM
  • UPPER
• Date and Time Functions
  • CURRENT
  • DATE
  • DAY
  • EXTEND
  • MDY
  • MONTH
  • TODAY
  • WEEKDAY
  • YEAR
• Analitic and Aggregate Functions
  • AVG
  • CARDINALITY
  • MAX
  • MIN
  • RANGE
  • STDEV
  • SUM
  • VARIANCE
• Conversion Functions
  • CAST
  • DECRYPT_CHAR
  • DECRYPT_BINARY
  • ENCRYPT_AES
  • ENCRYPT_TDES
  • GETHINT
  • HEX
  • TO_CHAR
  • TO_DATE
  • UNITS
• Environment and System Functions
  • CURRENT_ROLE
  • DBINFO
  • DBSERVERNAME
  • DEFAULT_ROLE
  • IFX_ALLOW_NEWLINE
  • IFX_REPLACE_MODULE
  • USER
• Other Functions
  • CASE
  • DECODE
  • FILETOBLOB
  • FILETOCLOB
  • LOCOPY
  • LOTOFILE
  • NVL

SQLWays Product Page Free Evaluation