Share this page:

Oracle/PLSQL: Functions - Listed by Category

For easy reference, we have provided a list of all Oracle/PLSQL functions. The list of Oracle/PLSQL functions is sorted into the type of function based on categories such as string/character, conversion, advanced, numeric/mathematical, and date/time.

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 category (ie: type of function).

String / Character Functions

Conversion Functions

Advanced Functions

Numeric / Mathematical Functions

Date / Time Functions

Miscellaneous Functions