Oracle / PLSQL: Functions - Listed Alphabetically
For easy reference, we have provided a list of all Oracle/PLSQL functions. The list of Oracle/PLSQL functions is sorted alphabetically based on the function name.
These functions can be used in SQL statements or queries in Oracle. Or, they can be used within the programming environment provided by the Oracle/PLSQL database, such as stored procedures, functions, triggers, etc.
Below is the list of Oracle/PLSQL functions, sorted by alphabetically by function name.
ABS
ACOS
ADD_MONTHS
ASCII
ASCIISTR
ASIN
ATAN
ATAN2
AVG
BFILENAME
BIN_TO_NUM
BITAND
CARDINALITY
CASE
CAST
CEIL
CHARTOROWID
CHR
COALESCE
COMPOSE
CONCAT
Concat with ||
CONVERT
CORR
COS
COSH
COUNT
COVAR_POP
COVAR_SAMP
CUME_DIST
CURRENT_DATE
CURRENT_TIMESTAMP
DBTIMEZONE
DECODE
DECOMPOSE
DENSE_RANK
DUMP
EMPTY_BLOB
EMPTY_CLOB
EXP
EXTRACT
FIRST_VALUE
FLOOR
FROM_TZ
GREATEST
GROUP_ID
HEXTORAW
INITCAP
INSTR
INSTR2
INSTR4
INSTRB
INSTRC
LAG
LAST_DAY
LAST_VALUE
LEAD
LEAST
LENGTH
LENGTH2
LENGTH4
LENGTHB
LENGTHC
LISTAGG
LN
LNNVL
LOCALTIMESTAMP
LOG
LOWER
LPAD
LTRIM
MAX
MEDIAN
MIN
MOD
MONTHS_BETWEEN
NANVL
NCHR
NEW_TIME
NEXT_DAY
NTH_VALUE
NULLIF
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
POWER
RANK
RAWTOHEX
REGEXP_COUNT
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REMAINDER
REPLACE
ROUND (dates)
ROUND (numbers)
ROWNUM
RPAD
RTRIM
SESSIONTIMEZONE
SIGN
SIN
SINH
SOUNDEX
SQRT
STDDEV
SUBSTR
SUM
SYS_CONTEXT
SYSDATE
SYSTIMESTAMP
TAN
TANH
TO_CHAR
TO_CLOB
TO_DATE
TO_DSINTERVAL
TO_LOB
TO_MULTI_BYTE
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TRANSLATE
TRIM
TRUNC (dates)
TRUNC (numbers)
TZ_OFFSET
UID
UPPER
USER
USERENV
VAR_POP
VAR_SAMP
VARIANCE
VSIZE
Miscellaneous Functions
Advertisements