PL/SQL Functions

Oracle PL/SQL Functions

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:

LENGTH returns the number of characters in a string.

SUBSTR returns a specified portion of a string.

INSTR returns the position of a specified substring within a string.

TO_DATE converts a string to a date.

TO_CHAR converts a date or number to a string.

ROUND rounds a number to a specified decimal place.

TRUNC truncates a number to a specified decimal place.

MOD returns the remainder of a division operation.

NVL returns the first non-null expression in a list of expressions.

COUNT returns the number of rows returned by a query.

SUM returns the sum of a column’s values in a query.

AVG returns the average of a column’s values in a query.

MAX returns the maximum value of a column in a query.

MIN returns the minimum value of a column in a query.

UPPER converts a string to uppercase.

LOWER converts a string to lowercase.

These functions can be used in SQL statements and PL/SQL blocks to manipulate data and perform calculations.

Avg Chr Coalesce Concat
Count Decode Extract Instr
Length Lpad Ltrim Max
Min Mod Nvl Nvl2
Replace Round Rpad Rtrim
Substr Sum Translate Trim
Trunc To_char To_date To_number
Dense_Rank Rank Listagg Sys_Connect_By_Path