Oracle SQL Functions

Here you will find complete list of Oracle SQL Functions:

Numeric Functions

Large Object Functions

BFILENAME
EMPTY_BLOB, EMPTY_CLOB

Hierarchical Function

SYS_CONNECT_BY_PATH

Data Mining Functions

Encoding and Decoding Functions

DECODE
DUMP
ORA_HASH
VSIZE

NULL-Related Functions

COALESCE
LNNVL
NULLIF
NVL
NVL2

Environment and Identifier Functions

SYS_CONTEXT
SYS_GUID
SYS_TYPEID
UID
USER
USERENV

Aggregate Functions

Analytic Functions

AVG
CORR
COVAR_POP
COVAR_SAMP
COUNT
CUME_DIST
DENSE_RANK
FIRST
FIRST_VALUE
LAG
LAST
LAST_VALUE
LEAD
MAX
MIN
NTILE
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
RANK
RATIO_TO_REPORT
REGR_ 
ROW_NUMBER
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
VAR_POP
VAR_SAMP
VARIANCE

Object Reference Functions

Model Functions