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
CONVERT
DECODE, SIGN
FLOOR
GREATEST
GROUPING_ID
HEXTORAW, RAWTOHEX
INITCAP
LEAST
MOD
NVL2
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
Regression - 
  REGR_SXX, REGR_SXY, REGR_SYY
  REGR_AVGX, REGR_AVGY, REGR_COUNT

Standard Deviation, Sample, Population - STDDEV, STDDEV_SAMP, STDDEV_POP 
Variance, Population, Sample - VARIANCE, VAR_POP, VAR_SAMP


String Functions

CONVERT
INSTR
REVERSE
SOUNDEX
SUBSTR

XML Functions

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

  Other Oracle Reference   11g    12c    19c    21c    Oracle Abbreviations
Top


Oracle registered trademark of Oracle Corporation.

Last Revised On: October 31st, 2023

  24935