Oracle SQL Functions Index (used in the queries)
Useful Oracle functions used in queries in this website

APPROX_COUNT_DISTINCT
BITAND
BIN_TO_NUM
CUBE, GROUPING, GROUPING_ID
GROUPING, GROUPING SETS
CASE
CAST
CEIL
COALESCE
DECODE, SIGN
FLOOR
GREATEST
GROUPING_ID
HEXTORAW, RAWTOHEX
INITCAP
LEAST
POWER
ROLLUP
TO_CHAR
TRANSLATE
VALIDATE_CONVERSION
WIDTH_BUCKET

Analytic Functions

COUNT(*) OVER()
DENSE_RANK
FIRST
FIRST_VALUE
LAG
LAST
LAST_VALUE
LEAD
LISTAGG
NTILE
PERCENT_RANK
RANK
RATIO_TO_REPORT
ROW_NUMBER
SUM(..) OVER()

Date and Time Functions And Constants

ADD_MONTHS
CURRENT_DATE, CURRENT_TIMESTAMP
DBTIMEZONE, SESSIONTIMEZONE
EXTRACT
FROM_TZ, TO_TIMESTAMP, TO_TIMESTAMP_TZ, TZ_OFFSET
LAST_DAY, NEXT_DAY
LOCAL_TIMESTAMP, SYSTIMESTAMP
MONTHS_BETWEEN
NEW_TIME, SYS_EXTRACT_UTC

Regular Expression

REGEXP_COUNT
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_SUBSTR

Statistical Functions

Correlation CORR
Covariance Sample, Population COVAR_SAMP, COVAR_POP
Regression Slope, Intercept  REGR_SLOPE, REGR_INTERCEPT
Standard Deviation, Sample, Population STDDEV, STDDEV_SAMP, STDDEV_POP
Variance Population VAR_POP

String Functions

INSTR
SUBSTR

XML Functions

XML_COMMENT, XMLELEMENT, XMLPI, XMLROOT, XMLParse, XMLQUERY, ....

  Other Oracle Reference   11g   12c

Oracle registered trademark of Oracle Corporation.

Last Revised On: May 31st, 2019

  33532