• 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
  • ADD_MONTHS
  • CURRENT_DATE
  • CURRENT_TIMESTAMP
  • DBTIMEZONE
  • EXTRACT (datetime)
  • FROM_TZ
  • LAST_DAY
  • LOCALTIMESTAMP
  • MONTHS_BETWEEN
  • NEW_TIME
  • NEXT_DAY
  • ROUND (date)
  • SESSIONTIMEZONE
  • SYS_EXTRACT_UTC
  • SYSDATE
  • SYSTIMESTAMP
  • TRUNC (date)
  • TZ_OFFSET
• 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
  • ASCIISTR
  • BIN_TO_NUM
  • CAST
  • CHARTOROWID
  • COMPOSE
  • CONVERT
  • DECODE
  • DECOMPOSE
  • DUMP
  • HEXTORAW
  • NUMTODSINTERVAL
  • NUMTOYMINTERVAL
  • ORA_HASH
  • RAWTOHEX
  • RAWTONHEX
  • ROWIDTOCHAR
  • ROWIDTONCHAR
  • SCN_TO_TIMESTAMP
  • TIMESTAMP_TO_SCN
  • TO_BINARY_DOUBLE
  • TO_BINARY_FLOAT
  • TO_CHAR (character)
  • TO_CHAR (datetime)
  • TO_CHAR (number)
  • TO_CLOB
  • TO_DATE
  • TO_DSINTERVAL
  • TO_LOB
  • TO_MULTI_BYTE
  • TO_NCHAR (character)
  • TO_NCHAR (datetime)
  • TO_NCHAR (number)
  • TO_NCLOB
  • TO_NUMBER
  • TO_SINGLE_BYTE
  • TO_TIMESTAMP
  • TO_TIMESTAMP_TZ
  • TO_YMINTERVAL
  • TRANSLATE ... USING
  • UNISTR
  • VSIZE
• 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
  • NLS_CHARSET_DECL_LEN
  • NLS_CHARSET_ID
  • NLS_CHARSET_NAME
  • SYS_CONTEXT
  • SYS_GUID
  • SYS_TYPEID
  • UID
  • USER
  • USERENV
• 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

SQLWays Product Page - Migration to Oracle Free Evaluation