SQL functions are used exclusively with SQL commands within SQL statements. There are two general types of SQL functions: single row (or scalar) functions and aggregate functions. These two types differ in the number of database rows on which they act.

Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format enables them to operate on zero, one, two, or more arguments: function (argument, argument, ...)

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.

This is a comprehensive list of Oracle SQL functions, grouped by type, and with descriptions. More information is available for each function here.

Tutorial and How to use Oracle SQL Functions, Math, Character, Single Row, Aggregate Functions with examples

Just as you can in other languages, you can create your own functions in Oracle. The syntax to create a function in Oracle is: [ (parameter [,parameter]) ] RETURN return_datatype. [declaration_section] executable_section. exception_section] When you create a procedure or function, you may define parameters.

SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions written in PL/SQL.

Sep 18, 2024 · Oracle SQL is a cornerstone in the data management landscape, offering robust functionalities that streamline database operations. One of its most valuable features is the wide array of built-in functions that enable users to perform complex data manipulations with ease.

The different types of functions in Oracle are −. More details about these functions are given as follows −. The following are the Oracle String Functions −. This function returns the ASCII or numeric value of the first word in the string str provided. If it is …

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.