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.

ABSACOSADD_MONTHSASCIIASCIISTRASINATANATAN2AVGBFILENAMEBIN_TO_NUMBITANDCARDINALITYCASECASTCEILCHARTOROWIDCHRCOALESCECOMPOSECONCATConcat with ||CONVERTCORRCOSCOSHCOUNTCOVAR_POPCOVAR_SAMPCUME_DISTCURRENT_DATECURRENT_TIMESTAMPDBTIMEZONEDECODEDECOMPOSEDENSE_RANKDUMPEMPTY_BLOBEMPTY_CLOBEXPEXTRACTFIRST_VALUEFLOORFROM_TZGREATESTGROUP_IDHEXTORAW

INITCAPINSTRINSTR2INSTR4INSTRBINSTRCLAGLAST_DAYLAST_VALUELEADLEASTLENGTHLENGTH2LENGTH4LENGTHBLENGTHCLISTAGGLNLNNVLLOCALTIMESTAMPLOGLOWERLPADLTRIMMAXMEDIANMINMODMONTHS_BETWEENNANVLNCHRNEW_TIMENEXT_DAYNTH_VALUENULLIFNUMTODSINTERVALNUMTOYMINTERVALNVLNVL2POWERRANKRAWTOHEXREGEXP_COUNTREGEXP_INSTRREGEXP_REPLACEREGEXP_SUBSTRREMAINDER

REPLACEROUND (dates)ROUND (numbers)ROWNUMRPADRTRIMSESSIONTIMEZONESIGNSINSINHSOUNDEXSQRTSTDDEVSUBSTRSUMSYS_CONTEXTSYSDATESYSTIMESTAMPTANTANHTO_CHARTO_CLOBTO_DATETO_DSINTERVALTO_LOBTO_MULTI_BYTETO_NCLOBTO_NUMBERTO_SINGLE_BYTETO_TIMESTAMPTO_TIMESTAMP_TZTO_YMINTERVALTRANSLATETRIMTRUNC (dates)TRUNC (numbers)TZ_OFFSETUIDUPPERUSERUSERENVVAR_POPVAR_SAMPVARIANCEVSIZE