See also Oracle Database SQL Language Reference for detailed information about SQL 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.

This page contains a list of all Oracle SQL functions. It contains SQL functions from Oracle 12c, as well as older versions such as 9i, 10g, and 11g. It's a great page for you to bookmark for future reference. …

How to develop a PL/SQL function and call it in various places such as an assignment statement and an SQL statement.

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

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.

Jun 15, 2024 · A PL/SQL recursive function is a function that calls itself to perform a specific task. The function continues to call itself until a certain condition is met, at which point it returns a value.

All functions in alphabetical order: 1 ABS (n) 2 ACOS (n) 3 ADD_MONTHS (date, integer) 4 APPROX_COUNT (expr) 5 APPROX_COUNT_DISTINCT (expr) 6 …

Oracle PL/SQL offers a wide range of built-in functions that can be used to perform various operations on data stored in the database. Some examples of Oracle PL/SQL functions include:

Sep 18, 2024 · This article delves into the various types of built-in functions available in Oracle and demonstrates how they can be effectively used to optimize your database workflows.