User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
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
ADD_MONTHS
CURRENT_DATE
CURRENT_TIMESTAMP
DBTIMEZONE
EXTRACT (datetime)
FROM_TZ
LAST_DAY
LOCALTIMESTAMP
MONTHS_BETWEEN
NEXT_DAY
ROUND (date)
SESSIONTIMEZONE
SYS_EXTRACT_UTC
SYSDATE
TRUNC (date)
TZ_OFFSET
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