Oracle Functions [Ispirer Migration Knowledge Base]

User Documentation Ispirer Capabilities - Oracle Migration Pricing

Oracle Functions

SQL Functions Mapping to Other Databases
Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- BITAND
- CEIL
- COS
- COSH
- EXP
- FLOOR
- LN
- LOG
- MOD
- NANVL
- POWER
- REMAINDER
- ROUND (number)
- SIGN
- SIN
- SINH
- SQRT
- TAN
- TANH
- TRUNC (number)
String Functions
- ASCII
- CHR
- CONCAT
- INITCAP
- INSTR
- INSTRB
- INSTRC
- INSTR2
- INSTR4
- LENGTH
- LENGTHB
- LENGTHC
- LENGTH2
- LENGTH4
- LOWER
- LPAD
- LTRIM
- NCHR
- NLS_INITCAP
- NLS_LOWER
- NLSSORT
- NLS_UPPER
- REGEXP_COUNT
- REGEXP_INSTR
- REGEXP_REPLACE
- REGEXP_SUBSTR
- REPLACE
- RPAD
- RTRIM
- SOUNDEX
- SUBSTR
- SUBSTRB
- SUBSTRC
- SUBSTR2
- SUBSTR4
- TRANSLATE
- TREAT
- TRIM
- UPPER
Date and Time Functions
Analitic and Aggregate Functions
- AVG
- CLUSTER_ID
- CLUSTER_PROBABILITY
- CLUSTER_SET
- COLLECT
- CORR
- CORR_S
- CORR_K
- COUNT
- COVAR_POP
- COVAR_SAMP
- CUBE_TABLE
- CUME_DIST
- DENSE_RANK
- FEATURE_ID
- FEATURE_SET
- FEATURE_VALUE
- FIRST
- FIRST_VALUE
- GROUP_ID
- GROUPING
- GROUPING_ID
- LAG
- LAST
- LAST_VALUE
- LEAD
- MAX
- MEDIAN
- MIN
- NTILE
- PERCENT_RANK
- PERCENTILE_CONT
- PERCENTILE_DISC
- PREDICTION
- PREDICTION_BOUNDS
- PREDICTION_COST
- PREDICTION_DETAILS
- PREDICTION_PROBABILITY
- PREDICTION_SET
- RANK
- RATIO_TO_REPORT
- REGR_SLOPE
- REGR_INTERCEPT
- REGR_COUNT
- REGR_R2
- REGR_AVGX
- REGR_AVGY
- REGR_SXX
- REGR_SYY
- REGR_SXY
- ROW_NUMBER
- STATS_BINOMIAL_TEST
- STATS_CROSSTAB
- STATS_F_TEST
- STATS_KS_TEST
- STATS_MODE
- STATS_MW_TEST
- STATS_ONE_WAY_ANOVA
- STATS_T_TEST_ONE
- STATS_T_TEST_PAIRED
- STATS_T_TEST_INDEP
- STATS_T_TEST_INDEPU
- STATS_WSR_TEST
- STDDEV
- STDDEV_POP
- STDDEV_SAMP
- SUM
- VAR_POP
- VAR_SAMP
- VARIANCE
- WIDTH_BUCKET
Conversion Functions
XML Functions
- APPENDCHILDXML
- DELETEXML
- DEPTH
- EXTRACT (XML)
- EXTRACTVALUE
- INSERTCHILDXML
- INSERTXMLBEFORE
- PATH
- SYS_DBURIGEN
- SYS_XMLAGG
- SYS_XMLGEN
- UPDATEXML
- XMLAGG
- XMLCAST
- XMLCDATA
- XMLCOLATTVAL
- XMLCOMMENT
- XMLCONCAT
- XMLDIFF
- XMLELEMENT
- XMLEXISTS
- XMLFOREST
- XMLPARSE
- XMLPATCH
- XMLPI
- XMLQUERY
- XMLROOT
- XMLSEQUENCE
- XMLSERIALIZE
- XMLTABLE
- XMLTRANSFORM
Environment and System Functions
Other Functions
- BFILENAME
- CARDINALITY
- COALESCE
- CV
- DATAOBJ_TO_PARTITION
- DEREF
- EMPTY_BLOB
- EMPTY_CLOB
- EXISTSNODE
- GREATEST
- ITERATION_NUMBER
- LEAST
- LNNVL
- MAKE_REF
- NULLIF
- NVL
- NVL2
- POWERMULTISET
- POWERMULTISET_BY_CARDINALITY
- PRESENTNNV
- PRESENTV
- PREVIOUS
- REF
- REFTOHEX
- SET
- SYS_CONNECT_BY_PATH
- VALUE