totn Oracle Functions

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/Char Functions

Numeric/Math Functions

Date/Time Functions

Conversion Functions

Analytic Functions

Advanced Functions

Miscellaneous Functions