Oracle Functions to HiRDB

Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- BITAND
- CEIL
- COS
- COSH
- EXP
- FLOOR
- LN
- LOG
- MOD
- POWER
- REMAINDER
- ROUND (number)
- SIGN
- SIN
- SINH
- SQRT
- TAN
- TANH
- TRUNC (number)
String Functions
- ASCII
- CONCAT
- INSTR
- LENGTH
- LENGTHB
- LENGTHC
- LOWER
- LPAD
- LTRIM
- NCHR
- REPLACE
- RPAD
- RTRIM
- SUBSTR
- SUBSTRB
- TRANSLATE
- UPPER
Conversion Functions
- ASCIISTR
- BIN_TO_NUM
- CAST
- CHARTOROWID
- COMPOSE
- CONVERT
- DECODE
- DECOMPOSE
- DUMP
- HEXTORAW
- NUMTODSINTERVAL
- NUMTOYMINTERVAL
- ORA_HASH
- RAWTOHEX
- TO_BINARY_DOUBLE
- TO_BINARY_FLOAT
- TO_CHAR (character)
- TO_CHAR (datetime)
- TO_CHAR (number)
- TO_CLOB
- TO_DATE
- TO_DSINTERVAL
- TO_LOB
- TO_NCLOB
- TO_TIMESTAMP
- TRANSLATE ... USING
- UNISTR
- VSIZE
Date and Time Functions
Analitic and Aggregate Functions
- AVG
- SUM
- COUNT
- DENSE_RANK
- GROUPING
- LAST_VALUE
- LEAD
- MAX
- MIN
- NTILE
- RANK
- RATIO_TO_REPORT
- SUM
- WIDTH_BUCKET
Environment and System Functions
- SYS_CONTEXT
- SYS_GUID
- UID
- USER
- USERENV
Other Functions
- COALESCE
- EMPTY_BLOB
- EMPTY_CLOB
- GREATEST
- LEAST
- LNNVL
- MAKE_REF
- NULLIF
- NVL2
- VALUE